what value i have to give to parameter name @sp-2 sysname in the procedure to execute as shown given below

create procedure dba_GetDependencies1 @sp-2 sysname

I tried to execute the code again but still its not working

Now Its Giving error in the section given below

INSERT INTO DimTime

SELECT

TimeKey,

????TimeFullDate,

????TimeDayNumberOfWeek,

especially for TimeKey and TimeFullDate

Your code is not working. It 's giving error ColRowNo is invalid Column. Can you please try to remove that error from your code. I executed that code in...

Your code is not working as tried to execute in SQL SERVER 2008. Its showing some syntax error in the code section given below :

SET DATEFORMAT MDY;

DECLARE @StartDate DATETIME...

Actually you are right that i want to understand how that code is working.Only was able to understand Common Table Expression out of this script. Actually I want to understand...

Can someone explain me how the script given below is working ?

Especially the CASE Statement

DECLARE @Text NVARCHAR(2000)

DECLARE @StringDelimiter CHAR(1)

SELECT @Text = 'This T-sql will split senteneces into...