It means you can't use the new features in SQL Server 2005 on any of those databases. This includes keywords such as ROW_NUMBER, and the dynamic management views.

John

Are you talking about splitting the string, or reassembling it...

Resender (12/9/2010)

---

OK,

I believe set-based query to split my columns was already in my stored procedure

SET @truncatedChar = REPLACE(@SelectedColumns,',','')

SET @occurenceChar = (LEN(@SelectedColumns) - LEN(@truncatedChar))

...

WHILE (@counter < @occurenceChar...

Shouldn't be any reason to do any looping. The splitting of the string can be done with...

Oh. Maybe it's been taken down for maintenance. If you do a Google search for it, you can look at the cached version.

John

Ah yes, so they are. Please have a read of this...

http://www.sommarskog.se/dynamic_sql.html

... and decide whether you're still happy with this way of coding. If you are, then what...

I can't find where you're setting the value of @SelectedColumns. This is the important part. You need to get the data types of the columns you are returning...

There has been much discussion on this in the past, some of it rather partisan. Please search for attaching versus restoring, have a read, and then post back if...

OK, so it depends on the data types of the columns returned, not of the parameters. Please post your code and table DDL so that we can help you.

John

What do you mean by size? Do you mean number of rows? If so, use the TOP keyword. If you mean number of KB, I think it's...

Isn't it just that you need to alias your subquery (as Kit originally suggested) - something like this:

select nr_praktijk, naam_praktijk, jaar_k, kwartaal_k, aantal from lvr_praktijken

inner join zsk_kwartalen on nr_praktijk...

Kat

None of us are paid to do this and we do it in our own time, so the easier you make it for us to help you, the more likely...

ddezwaan (12/5/2010)

---

At the risk of sounding like a nit-picking pedant, in international English one says 'more quickly'.

I.e. 'my query runs more quickly', not 'my query runs quicker'

The days of grammatically...

Kat

Please provide table DDL, sample data in the form of INSERT statements and expected results. That way we can visualise your problem properly and give you a tested solution.

Thanks

John

Exactly - so you need to specify which G you want. Qualify your column name so that it is "TP.G" or...