As to the CTE's moving into table variables, I just took some queries that were CTE's and declared a table variable with a primary key to hold the results instead,...

At least in SQL Server 2005, the PIVOT and UNPIVOT operators need to know the values they'll be dealing with, so if you don't know ALL the possible values, and...

Why thank you kind sir !!! I was going bananas trying different ways to parenthesize, add aliases, etc., but I think I just got so buried deep into...

If I recall correctly, the EXECUTE statement needs the @s-2 to appear in parentheses, as follows:

EXECUTE (@s);

Steve

(aka smunson)

:):):)

Before I worry about performance, I have some reservations about just adding another table. When you mentioned the idea of perhaps having a price column as part of the...

Getting the SQL Native Client on each of the reporting PCs means having to go through that step/process for each one, in the same way that we desire NOT to...

Whatever came with Crystal Reports XI, so no, I have no idea if it's up to date or not. Any ideas on how I can find out rather...

Take note of the added parentheses around @sql in your EXEC statement...

Steve

(aka smunson)

:):):)

smerg (7/8/2008)

---

Hi all,

I'd like to convert several rows of my table to csv list

create table...

If I do that, then I have to assume that the query is being fed to SQL Server in pieces, and given the results already achieved, that can't be true....

The reason for the change is to eliminate the need to maintain the ODBC configuration on multiple PC's, which is what should be an unnecessary step. The report...

First, I tried just looking at the execution plan, which I had never seen before because I so rarely encounter a query that runs for any significant amount of time,...

First, I suspect the following code will run VERY POORLY, but here goes anyway, and if EmployeeId is not the Primary Key field in the Employee table, replace that in...

You'll have to look at the Orders table to ensure that Title is a field within it. If it's supposed to come from Employees instead, then I'll have to...

Matt,

I by no means advocate a loop solution, but was just trying to get the OP to come clean on the whole deal instead of feeding it in piecemeal. ...

Really? Perhaps you need to restate the problem. What it appears you are asking for is a solution to a general class of problem: Using...