Cross tab result is always required and it is bit complex in case of dynamic column. If column name has to be dynamic then this is the good idea to have the PIVOT Query, for example I have 3 Tables and data like this: First Tabl...

Thanks for sharing your views !...

Thanks for sharing your views !...

Hi Marc, Thanks for your nice comments, Can we run the Bulk insert using UNC path or not ? or previous version also support the same or not ? In your question "what do you do when the password has to be changed?" - Each time that script is us...

Hi Marc, Thanks for your nice comments, Can we run the Bulk insert using UNC path or not ? or previous version also support the same or not ? In your question "what do you do when the password has to be changed?" - Each time that script is us...

I am a SQL purist, meaning that I have vowed never to use cursors in T-SQL to loop through rows record by record. In SSIS package design, however, I have used the Foreach Loop Container very often. I would not say that I have brok...

We can use this script to show the row data in string....

We can use this script to show the row data in string. Name ------ RAM SHYAM HARI RITA Name RAM,SHYAM,HARI,RITA --Use the following query DECLARE @strList varchar(100) SELECT @strList = COALESCE(@strList + ', ', '') + C...

We can use this script to show the row data in string. Name ------ RAM SHYAM HARI RITA Name RAM,SHYAM,HARI,RITA --Use the following query DECLARE @strList varchar(100) SELECT @strList = COALESCE(@strList + ', ', '') + C...

specify size and press OK3) Now see your log and file size. SELECT name AS [FName] , file_id, physical_name AS [Phy.Name], size/128 AS [SizeInMB], size/128.0 - CAST(FILEPROPERTY(name, 'Used'......