Brewmanz... keep them coming. That was great, and exactly what we all need! Good explanation, too. I found that it was dependent upon order, but could not figure...

Same type of logic here, but almost impossible to wrap one's head around the derived table and correlated subquery.

To this day, I still have to deal with code that looks...

There are a couple of ways to skin the cat, but lately CTE's are in style.

Here I am creating a temp table for demonstration:

CREATE TABLE #TEST

(Customer_id INT,

last_name VARCHAR (25),

...

Hey there Larson,

When you say time stamp... is that column the datatype of timestamp or datetime?

Can you provide the definition of your table?

SELECT COLUMN_NAME, DATA_TYPE

FROM INFORMATION_SCHEMA.COLUMNS

...

SMPSMERS,

Did you get it worked out?

Seems to me like if you moved the ReportServer and ReportServerTemp dbs to another server, verified the account that you are connecting with, and change...

And I third the suggestion!

More often than not, tune the queries. That is the first place to start, and the biggest gains can be achieved there. I've seen...

Aiwa,

I am confused by the source of your data to be inserted into resultTB. You say you have 2 different tables as source, but only list TB1.

Also, is newColID...

Aha,

I am wrong in assuming COUNT (1) refers to the first column.

SELECT COUNT (25)

--or

SELECT COUNT ('something')

these both return 1, as the count of the literal expression, be it integer...

KB,

The 1 in count 1 refers to the column in the first ordinal position, 2 the second, 3 the third, etc.

Here is a good example below...

CREATE TABLE #TEST

(A...

It had been a while since I wrote the question, and I MISSED IT! The subtle but important difference between count (*) and count (columnname) is something I will...

Cursor datatype, huh? Does somebody have any sample code to demonstrate? I've never used it before...

JM,

The SQL 2000 install program is cluster aware... so in the install when you get to Computer Name dialog box, check the Virtual Server button (opposed to Local or Remote)...

Absolutely brilliant. Thanks again. I've got a new wrench in the toolbox!

Jeff,

You're the master of set based thinking. Thanks for the contributions and the recent article on the tally tables. It is starting to form in my head (as...

Yup, that functionality is the same between 2000 and 2005.

You will receive a message in Enterprise manager... The filename specified is incorrect. A new log filie may be created. ...