If the purpose was to save paper, why not do a sort of pivot query and put all the prices for each line item on a seperate line?

Hey Jeff,

What's so cool about your solutions, one can cut and paste them into QA and run them!  And......they work!  Great job.

Steve

Does the same return for True?  i.e., if exp1 evaluates to True does it return true?

Rather lengthy and sorry about the formatting, but this is one I'm currently using in production on SQL2000.  We are porting some of this data to SQL2005 servers and I...

"SQL2000 and earlier versions should never have allowed ORDER BY in a view. Period."

Hey PW,

Does this also mean that Case Statements used in views which work for SQL2000 but are...

I agree with the above however, keep in mind that some states are in more than one time zone. How are you making the time determination?  Do you only have state, or is...

One way, there may be a simpler way.

SELECT cast(convert(decimal(8,1),100.0 *(COUNT(DateCol)/110.0))as Varchar)+'%'

FROM @table

Thanks Chuck.  So much to learn, so little time!

Maybe too simple, but did you try this:

insert into table

select Max(cast(column as Varchar)) from Table1

Big company or not, if the only customers one would lose are ones who will take advantage and be less than honest about paying for what they received, I would...

"Anyone that has to ask, "What's the right thing to do?" has a problem with their moral compass. "  Bert Carles. 

Right on Bert.  If you agreed to the offer, then follow...

"This code will always return a value of 0 for Monday, 1 for Tuesday,...,  6 for Sunday, no matter what the setting of datefirst is."

Why would BOL seem to refute...

Double check that the Day of the Week is the correct one for how you are using this.  Some systems use Sunday as the 1st day (Default) and others use...

Is there any time where multiple users will be accessing this proc concurrently?

If so, this may cause problems with inaccurate ID's because there is a chance that another user can...

Narendra,

Check this out.

http://www.sqlservercentral.com/columnists/yShlafman/thebestkeptsecretaboutsqlqueryanalyzer.asp