I thought we were being intelligent shoppers by looking for the best value for our dollar!!

DSP you are right on the money on this one. I just wonder how much...

Tom if you could supply us with your table structure, some sample data and the expected results we could supply you with the informaton your requested.

Mike

Raj if I read your original post correctly you want all the Draw_IDs where there are no values for any of the Draw_Nubers. Then using or in your select will...

 I am not sure exactually what you are looking for. From BOL on rollback

Transactions are managed at the connection level. When a transaction is started on a connection, all Transact-SQL...

"world has opened it's eyes and can handle (for the most part) seeing that all employees are treated fairly."

And one of the reasons employers treat employees fairly is that they...

I am  not sure how the state could force management or anyone else for that matter to join a union. Union membership is covered by the NLRA (National Labor Relations Act). If you...

Mark much better and alt minus minus will take you back.

Mike 

Mike - who's one-armed and why ?!

Perhaps moi the last time I claimed to be a wit my son claimed that I...

Tony, its a shame that sushila actually took time off to work and missed the fray. A sharp brain and quick wit. When engaging her in a battle of wits one never...

Wayne you have some valid points. The decesion to outsource is complex and making a decision without taking the time to consider all factors leads companies into trouble. While you are...

Have unions ever worked? I would suggest reading a history of the labor movement in the United States. Many of the benefits of employees in the US are the direct...

One of my favorite quotes from Peanuts back in the early 07's. "I love mankind it's people I can't stand." 

I have to also agree with Voltaire who said something...

Good choice much cheaper than a new wife.

Mike

Ed I love your quote and remember its not possible to under estimate the the IQ of a typical user

Mike 

The data is stored in your database

IF Object_ID('tempdb..test') >0

 DROP TABLE Test

CREATE TABLE Test

(

 SomeData varchar(20)

)

INSERT INTO Test VALUES('A')

INSERT INTO Test VALUES('B')

INSERT INTO Test VALUES('C')

INSERT INTO Test VALUES('D')

Select * from Test

/*

Returns 4...