Very missleading title of video, it is not about a "timestamp" column type.

Nice explanation, Thank you guruji

👍

Very good example. Thank you.

Hi Ramana How fast can we learn SQL and SSIS Since I'm a beginner

Thanks bro

my sp returns 3 select statement as output how to insert 3 outputs into 3 different tables , all tables have same columns but different data

Hi sir here recently I joined a company in. As 4 years of experience in SQL and SSIS .but I have done a course of this which I didn't work in real-time project .. So I'm very much afraid Is there any solution for this

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