You mean a correlated subquery, Grant?

No... You cannot INSERT into scalar variables... tell us...

It because you're trying to put something too big into a column too small. It usually means there's an error in the file... might be a transmission error or...

Christopher Stobbs (7/11/2008)

---

Thanks for that.

I'm actually look for more of an Analytical question rather than tech skills questions...

For example giving them puzzles to see what there approach to problem solving...

Loner (7/11/2008)

---

There are two rooms separating by a wall, one room has three lamps, the one one has three switches, can you tell how to find out which switch is...

rameshchandra.a (7/11/2008)

---

4.What are temperory tables.(perfermence wise cursors r Temperory Tables which are better)

If a WHILE loop is involved, then each will suck as bad as the other

5.What is CTE(Common Table...

Heh... I always get what I want because the best things in life... are not things. 😛

mblack (7/11/2008)

---

Thanks for the help. I'm getting a syntax error i believe by my GROUP BY. The message is:

Msg 102, Level 15, State 1, Line 23

Incorrect syntax near ')'.

Other than...

... or correlated subquery.

Spot on, Gus. 🙂

Why? What do you think a cursor is, anyway? It's nothing but an internal table with a...

antonio.collins (7/10/2008)

---

before i write some awful case statements or multiple UDFs, is there any direct way to determine if any values in a list are negative?

coalesce_negative( 1, 1, 1,-1, 1,-1,-1,-1,...

That's not true...

Heh... good idea... just remember that TRUNCATE won't work in the presence of Foreign Keys... 😉

What Barry means is that you've given us nothing but symptoms. The problem is going to be what appears in the...

What you've requested is not a Pivot... it's a "simple" aggregation. Since you've not identified the datatypes involved, I have to make certain assumptions. Please see the link...