You could use something like this.

DECLARE @median sysname,

@tablenm sysname

declare @sql nvarchar (max),

@med decimal(15,2)

set @sql = 'WITH MEDCTE (ID, MED)

AS (SELECT

Id,

AVG( ' + QUOTENAME(@median)...

You don't need a cursor or a cycle. There's an easier, shorter and quicker way to do it.

You can read about it on this article. http://www.sqlservercentral.com/articles/comma+separated+list/71700/

SELECT CompanyCode,

Login = STUFF((

...

You might have a character that might not be a space.

You can check which character is with this code (it's untested, but it should work).

WITH E1(N) AS (

...

You could try something like this

DECLARE @cDate varchar(5) = '20114'

SELECT DATEADD( MONTH, RIGHT(@cDate, 1) , CAST( LEFT(@cDate,4) + '0101' as DATE))

2011401 does not have a common format for a date. Can you explain which is the year, month and day?

Which link?

As I said, there are some risks...

You could use CTEs instead of the temporary tables. However, you should check for any possible performance issues.

WITH MOVEMENTS AS(

SELECT *

FROM [GW_DW].[dbo].[DimStatusHistory] d

WHERE TransferFromToProgram <> ''

AND d.STATUS = 12

),

NEW_MOVEMENTS...

Check for something like this. If you have problems, it might be a permissions problem.

EXEC xp_cmdshell 'DEL "C:\My\Full\Path.bak" /Q';

GO

I wouldn't advice to use undocumented procedures on a production environment, but...

You could try using xp_cmdshell 😉

You'll always be welcome here to learn as we all learn here.

The error you're getting is because the rollno on the order by is not qualified. Just add "s." before...

If this post was...

I didn't read the previous posts. The idea is really similar, but I'm not using a temp table (I probably should). This would be a lot easier on 2005+

SELECT s.*...

Scott,

I believe that Sue is mentioning the CTE that's included in the 8K Splitter that I mentioned.

You don't need to cast it, an implicit conversion will transform strings into integers if the column only contains digits. If there's a non-integer value in your column, it will...

Are you checking that the .bak file exists on the server and not on your desktop?