It all depends on what you are trying to achieve i use temp tables all the time and it really does not affect performance that much.

if your results are only...

Yes i have not noticed that thread until after i had replied 🙂

from the info you have provided i assume that the data is in 1 table so your query should looks something like this

select collum, collum, collum

from table

where collum ='True'

and...

Hi if you want to search in your table where the name filed has a leading or trailing space you could use the following

select * from table

where patindex('%...

can you elaborate a bit more please if i search for the ascii value of c and C the values are different

c=99 and C=67

sorry there are 446 quaters bettween 1899-12-31 00:00:00.000

and now not 466

The DATEADD() function adds or subtracts a specified time interval from a date.

Syntax

DATEADD(datepart,number,date)

qq = quarter

yy = Year

in your question the date field is representative as 0 or -1, in the...

Your code appears to use the ASCII character however, this previous answer looks incorrect. the ascii value for CHEAT = 67 and ascii value for CZZZZZZZZZZ=67

if you do select ascii('Cheat')...

Not sure what you’re trying to achieve however, would it not be actually be better to just list all the orders in descending order then your boss would see all...

Lutz, sorry for delayed response, yes tried your script and fantastic thanks wokes slightly different to mine but wow the performace is very good using the stuff thank you....:-D

Hi Lutz,

I have tampered with the script you provided but cant get it to retrieve the results that i need.

I use SQL2000 and SQL2005 depending on what DB im working...

Never used stuff before

whats the FOR XML bit used for? as i constantly get a syntax error saying incorrect syntax near xml

Thanks Lutz,

i have worked out a method for doing this now,

Step 1 create table with all my results in it, 2 create update table

step 3 create cursor to insert into...