I guessed 2 because BETWEEN is inclusive, and then I tried to run it. I found out that I needed SQL Server 2008 compatibility, don't have that, only 2005,...

Good catch, thank you.

It turns out that @table was empty because I used a database where the sys.master_files table was empty; therefore, no rows for the cte...

Live and learn

🙂

With the given SQL, @temp is an empty table, therefore count(1) will always return 0.

-- Sorry, I get 1 for count(1) using datalength(), record 8.

-- count(1) for Len() rerturns 0

-- What am i doing wrong?

oops, nevermind...

RBAR comes through again, good work.

Requirement added: However, I don’t want it to overwrite a null salary amount for the next employee if they happen to have a null at...

These return different results for the end of months preceding a month that has more days in it. For instance January has 31 days, and February only 28 or...

Very helpful, thanks. You can also take out the dangling delimiter...

DECLARE @var varchar(8000)

SET @var = ''

SELECT @var = @var + FieldName + '/'

FROM Table

SET @Var = substring(@Var,1,len(@Var)-1)-- Removes trailing...