วีดีโอ

Excellent

Thanks. Please notice that in your video the number of stars does not match the number of characters in the username. For example, for john.doe it should be j******* but in your caes it has 9 stars. You probably need to adjust your replace number with minus 2.

Say for example it wasnt months but a Type that you dont know at runtime. How could you create the folders based on the type and create the file and then write the corresponding data

What about using cascading delete on the foreign key definition

Hi. Are you providing personal teaching ? or work ?

Hi , can't we use proper case in SSIS?

this seems easier: -- Count number of occurences of a value in a string declare @myvar varchar(max), @tocount varchar(20) set @myvar = 'Hello World, Hello World' set @tocount = 'World' select (len(@myvar) - len(replace(@myvar,@tocount,''))) / LEN(@tocount)

very helpful...can u make videos on how to use CASE WHEN with different statement clauses like FROM,ORDER BY, CASE with JOINS...

But that didn't extract the numeric values

Good explanation anna

thanks, here is another approach with cte as ( select 100 as A union all select 200 as A union all select 300 as A union all select 400 as A ) Select max(a) from cte

Wilson Betty Hernandez Mary Young Michelle

Davis Carol White Timothy Robinson Richard

In Recent open i don't have any thing how can i select integration services import

Many thanks for amazing video

good video , but what if i have the date parameters in the sp like fromdate and todate? how to do this?

Thanks for teaching.

What's the point of this ? if a value is 608 then you wouldnt want to remove the zero surely...

Why are you substring'ing CountryCode? At least just ltrim it or on its own

I don't understand.

great

Thank you sir

Thanks for the Article, we can write this way also for same salary employees query select * from Employeedetails a join Employeedetails b on a.Salary=b.Salary and a.Emp_Id!=b.Emp_Id

Thanks but instead of the partition, could you not have just used distinct?

The audio on this is not good, sounds like you're under water

Nice explanation..Thank you

Good videos

I am trying to insert values in my tables and its giving me this error message: ERROR: null value in column "i" violates not-null constraint DETAIL: Failing row contains (null, bar).

That ran in 0 seconds... also why is the join backwards: soh2.salesorderid = soh1.salesorderid

How to copy an SSIS package from one Solution Explorer to another (i mean from one system to another, how to clone all the packages)?

Good video but you are not really using a Stored Proc for the export though...you are using the Import/Export Wizard

Thanks very helpful

Thank you very much sir

but if to replace in all columns ,how to use in one go

Between the audio clipping and the speakers heavy accent, this was very difficult to hear. Nice Try but I'd suggest some post-production audio clean up.

I have a single raw data flat file and I need to validate the total length of the file and load the row length into a sql database table , can you make a video on that 😮😮 great video by the way

Thank you so much, it worked well.

Shame on this video due to the record quality and its all aspects

Dude, do something about your pc fan I barely hear what you're saying.

Thank your for the video. It was helpful :) :).

Thank you very much!

how do I overwrirte the data in the sheet everytime

bro only 720 rows of data only loaded not all the three files data, Please update that.

Hi Anna.I followed your videos daily, it is giving lot of knowledge for who don't know dept of sql.i need your assistance in sql.I have some doubts on optimization of sql query in TSql.where can i reach you .

How can I know that the update was completed successfully?

Thank You

sir insert button duba lo us se theek ho ga cursor apka

after 1 hour of research i got your video which clears my doubt and query ... you are very helpful

Difficult to understand but somehow I managed to understand the concepts. Thank you.

Thank you for this video