-- See how you start off by actually creating a table

-- and then inserting the data into it? Doing this really

-- makes things a lot easier for all the...

Jeffery Williams (5/24/2010)

---

2. I am running SQL 2008 on a 64 bit machine. Some of the things I have tried are giving me problems because of this fact

INSERT INTO OPENROWSET...

athatipamula (5/24/2010)

---

I have a code using except function

can any one rewrite the code using sub queries?

I am using 2 databases and 2 different tables

here is the code:

SELECT [MODE],[NUMBER],[DESCRIPTION],[UNITSIZE]

FROM [database1].[DBO].[table1]...

The Dixie Flatline (5/21/2010)

---

A thought provoking question anyway....

I think "unique" should count twice or not at all. You can have unique clustered indexes and...

About 3 weeks ago, I was doing some research on a related topic and found that this answer is wrong. I had asked Steve to change this question then.

This QotD...

Yep... I took the week off, and among all the chores I had a list of 13 sessions I wanted...

Here's an approach that is similar to the one Lutz posted. As he did, it's based off of tally table.

Main differences are that you can specify the number of rows...

Slight modifications to the solution already provided by ColdCoffee, in order to show with the field name you specified. And a way to eliminate the case statement.

DECLARE @YOUR_TABLE TABLE

(

...

Perfectly...

Yes, it looks VERY nice!

LOL.

Actually, I found that avatar on a post out here on SSC... but the poster hadn't been active in quite some while. Might...

I would be interested in your solution to this also!

Thanks!

I agree with you Gary... it's a view (albeit into a system table).

And with Carlo also......

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

simflex-897410 (5/17/2010)

---

... rather than use WHERE EndDate BETWEEN @StartDate AND @EndDate, can I replace it with year so that users can just enter year to obtain the report for that...