Cristian Maidana-360609 (9/2/2010)

---

Hi, thanks for your answer.

bellow the original Query, when i implemented your suggestion, i have the "Msg 102, Level 15, State 1, Line 12

Incorrect syntax near ')'."...

Cristian Maidana-360609 (9/2/2010)

---

Hi, i was trying filtering a query with an alias, but it doesn't work

select a,b, (select count(*) as Tot from table2) as Tot

From table1

where (Tot > 0).

but the...

Sunshine.

And warm, too. Not bad for the UK in September.

pin the tail to the donkey.

CASE is used with values, you are attempting to use CASE to build part of a statement. You could go the whole hog and perform the latter successfully using dynamic...

Mythbuster.

You still here? 😛

stephenhai (9/1/2010)

---

My stored procedure has input parameter for branch id

if I provide the small branch (no of record is 1000), it takes 3 sec

if I provide the large branch (no...

Oh that Weird Al!

Must have been watching Deliverance the other night, put me off!

Horse Whisperer.

I'm old, Brandie - not heard of 'Weird Al'....

Marathon Man

Had to Google 'cos she's not really known over here. My word she's pretty.

Just back from a tour of the battlefields of the Hundred Years' War - Ray, you won't believe how much better you will feel for a few days away. Magic...

Who?

Jeff Moden (8/18/2010)

---

... I've had a whole lot of "well meaning" folks say that I'm a bit too "folksy" in my articles and that I should "write more professionally rather...

sing4you (8/19/2010)

---

Ray K (8/19/2010)

---

I would love to visit Russia someday. Maybe at some point, when I actually have money...