One last thought. Limit the number of chars in the rightmost column, AND set the width of that column in the properties of the combo box such that...

I'm first trying to understand why you want to have code to populate a combo box from a recordset ??? Why not just make the query the Record...

See your other post topic for the query I tried to develop once I realized what you were looking for.

Steve

(aka smunson)

:):):)

First, this post is part of a cross-posting. Please don't post a topic twice. As to what you seek, it would appear you may just need...

Levsha_z,

You appear to have changed your requirement. First, you asked for:

Now, you're asking...

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 my_contracts(

customer_id int,

contract_id...

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...