Post your query.  Sounds like a GROUP/COUNT problem.

Does the stored procedure have parameters?  Are you running the stored procedure with the same parameters as the ASP page runs it?

So change the select to read:

SELECT * INTO #d2 FROM deleted

SELECT @tcolname = ('SELECT '+@colname+' FROM #d2')

EXEC (@tcolname)

That will eliminate the error of #deleted already being there

Can you run that command in a CMD window ON the server?

CONVERT(CHAR(10), expression, 21) will convert the date to yyy-mm-dd

Are you deleting files that are older than a certain date?  In my backup jobs I just delete ANY non-zipped backups that are out there, then do my backup.  I also...

I guess Daryl beat me to the Post Reply button.

Try this:

SELECT CONVERT(CHAR(8),citrixfarm.SDB_SESSION.SESSIONSTART,101), COUNT(*)

FROM    citrixfarm.SDB_SESSION

INNER JOIN

 citrixfarm.LU_APPNAME

ON

  citrixfarm.SDB_SESSION.FK_APPNAMEID = citrixfarm.LU_APPNAME.PK_APPNAMEID

WHERE  citrixfarm.LU_APPNAME.APPNAME IN ('DESKTOP', '20 DESKTOP')

GROUP BY CONVERT(CHAR(8),citrixfarm.SDB_SESSION.SESSIONSTART,101)

One thing that you could try is to add the /n to the DIR command.  That will display the date as the first column in the results. 

If the row has...

Gotta disagree with your fellow colleague.  When you export the data, just turn off the identity column on the destination table and then turn it back on afterwards.  Make sure...

Can you post the exact code that you are having trouble with?  I have done a lot of work with xp_cmdshell and should be able to help you out.

I originally opened this post because I thought it was a joke.  (Hyderabad sounds like hire-a-bad)  Where is Hyderbad located?

I think I have a simple solution for you, but I want to be sure that I know what you want.

Do you want the column name to be the filename, or...

I had already found that out, I just hadn't had time to post the fix.  Why is there so many examples of using the Set command to assign variables on...

Excel wasn't installed on the server.  I assumed that it was because DTS had the ability to generate an excel file.  My original code now works.