I'm glad I could help. A lot of thanks...

The way I understand your post would mean that you are trying to use your database...

Is this what you have in mind?

SELECT SUM(CASE WHEN SID IS NULL THEN 1

...

Good that explains it 🙂

So first step, can you check the following:

SELECT SERVERPROPERTY('productversion')

Does this start with 9 or 8? If it is 8, then...

Hi Ahmad,

PIVOT statements have been introduced in...

For the first question the answer is that using top 1 is often resulting in a faster execution. (in a simple test case using top 1 resulted in fewer...

Any chance you could include the contents of the imagesBackup.sql file?

If you execute the contents in interactive mode, does it work?

Regards,

Andras

A simple question: does this folder actually exist on the server on which SQL Server is running? The xp_cmdshell is executed in the security context of the SQL Server service....

The reason is that SQL Server 2000 has much stricter rules on what it allows as parameters to table returning functions. So no function results, no variables, .... SQL Server...

Also see http://www.sqlservercentral.com/Forums/Topic443054-5-1.aspx. Same tools though. 😀 (of course I'm biased)

Regards,

Andras

Hi Ahmad,

you have not described what is stored in the monthwon column, nor did you give any sample data. So the following will be based on the assumption that monthwon...

You could change your case statement like:

CASE

WHEN [myRow] = 1 THEN 'True'

WHEN [myRow] IS NULL THEN 'False'

ELSE 'FALSE'

END

Andras

tadhg88 (1/21/2008)

---

Hi and thanks for ur reply i managed to get this working in Query Analyser but i was hoping to use the code in a

Function and i am...

Since you seem to be on SQL Server 2000 you cannot use row_number(). You could create a temporary table for the whole result, and populate it using:

select identity(int, 1,1) as...

OK, a first draft (may need some adjustment, but I do not have your data 🙂

DECLARE @cols NVARCHAR(2000)

SELECT @cols = STUFF(( SELECT DISTINCT TOP 100 PERCENT

...