thanks for the pointers.

i've tried the PIVOT but i'm not sure its quite what i'm looking for.

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/24ba54fc-98f7-4d35-8881-b5158aac1d66.htm

this example is taking the 'average cost' from each row of the table and...

perhaps do a 'between' statement

e.g

this would bring back everything that had the specified column between

23-06-2009 00:00:00 and 24-06-2009 00:00:00

dtApplicationTakenDt between CONVERT(varchar(50),getdate(),106)

and CONVERT(varchar(50),dateadd(dd,1,getdate()),106)

your SC.QUANTITY_UM column must be containing varchar data?

print 'hello' + char(13) + char(10) + 'world'

you can do something like that i suppose.

does your SP have an output parameter?

i'm not sure, but i think you could run the SP, assigning the output parameter to a variable and then put that...

i personally see nothing wrong with taking code off the internet and making it work for my purposes.

i'm still gaining an understanding of how it works.

not that i actively go...

they match for me.

not sure why they differ for you.

i think that if they were happy after the interview process then it was probably abit overkill to mention it again.

unless you were thinking that maybe they didn't hear you...

thanks!

i've basically got this

SELECT * FROM OPENQUERY(SERVERNAME,'CREATE INDEX i1 ON DATABASENAME.dbo.TABLENAME(Col1, Col2) SELECT 1')

it doesn't error, although i've gone to enterprise manager to check the indexes and i can't see...

RBarryYoung (4/30/2009)

---

I see a lot of folks trip over this: the "AVG() Overflow syndrome", as I like to think of it.

What's interesting about it is no one ever calls me...

SELECT DATENAME(WEEKDAY ,GETDATE())

do you have to find them or could you run a script that just updates all the rows?

update table

set col1 = upper(col1)

select

case when x.greating is null then 'nothing' else x.greating end

from

(

select

'hello' as 'greating'

union

select

'goodbye'

union

select

null

)x

use a case statement within your select part. if its null then output the string else output whats in...

select @EmailID, r.ssn, @EmailTypeId,........

or

select @EmailID,u.ssn. @EmailTypeId,........

not just select ssn

i personally prefer to set it as null.easier on the eye when looking through the database and working out whether it has a valid date against it or not.

but i...