Depending on why you need to do this, this might be useful:

SELECT @causename = causename from...

print replace(@causename,';',char(13)+char(10))

or this:

ISNULL(sum(dbo.INV_REC_JAN_JUNE_2010.RCP_QTY),0) as rcpt_qty,

isnull(SUM(dbo.INV_SHP_JAN_JUNE_2010.SHIP_QTY),0) as ship_qty,

I am thinking what you need is this:

select ProgressGroup,

min(ProgressDate) as Started,

case when max(ProgressDate) = min(ProgressDate) then ' ' else max(ProgressDate) end as Finished

from Progress where ProgressMessage in ('Start','Finished')

group...

You need to move to a 64 bit OS and 64 bit version of SQL server. You are running the boxes out of resources under heavy load and 32bit versions...

If you can modify the form and report code to utilize this derived data column than you can just as easily provide a leading zero formatted version of the column.

Personally...

The optimizer would probably treat them the same in this particular case. Personally tend to avoid the in line subquery method. If the value needs to be used in other...

The leading zeros are meaningless to SQL server. If your company wants to see them just modify the formatting on forms and reports so they appear that way. There...

Try this query and see if it isn't faster:

SELECT case when FKEntityID = @EntityID then RecordID else FKRecordID as FKRecordID,

FKPathID,

case when EntityID = @EntityID then RecordID else FKRecordID...

there is no doubt that breaking up a larger query into two smaller queries via a temp table can make a big improvement. You say you cannot use temp tables......

Thanks for making that point GregE.

Just so the original poster doesn't think I'm a grouch and since others did point a few of the more obvious problems, I will...

you're kidding me right? For one thing I couldn't even begin to analyze that query without spending a lot of time looking at the database tables and understanding the...

I was referring to adding a simple update statement in-line at the point of execution.

Obviously if it is called from many different locations (or dynamically generated SQL) he'll have to...

just increment a value in a table whenever the function is executed.

Note also that AWE can really only be used for some cache buffers. Much (if not most) of all the other data structures in SQL server for managing connections and...

A while loop is an execution control mechanism where a cursor is set of data (a result set ) that you can iterate through. In fact, the most common way...