BOL states

Unlike the syntax error in the previous example, an error that occurs during statement-level recompilation will not prevent the batch from compiling, but it will terminate the batch as...

could it be the Alias of your collated column?

you've called it 'Job Name' instead of 'Name'

i just tried it and it seemed to work

begin transaction

truncate table tablename

rollback transaction

didn't remove anything from the table

case

when (( Datepart(month,dtTemp) > 8 ) or ((Datepart(month,dtTemp) = 8)

and (DATEPART(WEEK,DAY(dtTemp))) = 1 )) then

'Sep-' + cast(right(datepart(yy,dtTemp),2) as varchar(30)) + ' to ' + 'Aug-' + right(datepart(yy,dtTemp)+1,2)

else

'Sep-' +...

i think its the comma at the end of this parameter that is being mentioned.

@Primaryagency_TTY varchar(700),

i see, thanks.

My thought process was, if the Stored Procedure code was created within the column of a Table, and then i was able to run all those Stored Procedures...

you want to evaluate two conditions in the same case statement like this?

select case when 1 = 1 and 2 = 2 then 'both' else 'not both' end

i see where i was going wrong.

i was right clicking the table name in the Object Explorer and selecting Edit Top 200 Rows and then typing in NCHAR(8486) into the...

that is the character i'm looking for. how would i store it as that character within the database though? I changed my database column to an nvarchar column and added...

rsnyderdba (7/13/2011)

---

Concerning 'auras' or haloes around lights such as car headlights at night. you may want to read up on Billberry. This was discovered by accident when Englsh WW2 pilots...

Matt S. (7/12/2011)

---

Please, go download Flux[/url] if you work after dusk or if you prefer a dark room. The warm colors it changes your monitor to are ideal for reducing...

this is certainly something that i would be interested in knowing as well. just out of curiosity really.

is this what your looking for?

select

distinct product

from @colour c1

where

(select COUNT(*) from @colour c2 where color = 'GREEN' and c2.product = c1.product) > 0

and (select COUNT(*) from @colour c3 where...

select RU,bu

,(select top 1 ent from @entity_list e2 where e2.RU = e1.RU and e2.BU = e1.BU)

from @#entity_list e1

group by RU,BU

could this work?

I wonder if there are other ways of doing this, or is this the accepted 'best' way?