Comment out your subqueries and replace with a static value. See if you still get syntax errors. If not, then there is a problem with one or more...

Anyone see the spoon? 😛

Here is one way:

select

[EmpId],

[EmpName],

cast([DeptId] as varchar) DeptId,

[Salary]

from

[dbo].[DirectEmp]

union all

select

...

Post the questions in Sanskrit? 😉

I have noticed several other issues. What would help is if you could provide the DDL for the tables (CREATE TABLE statements), sample data for the tables in a...

BaldingLoopMan (12/9/2009)

---

Are u saying if i'm using a #table and it has 10,000 recs then the optimizer may not optimize properly? Interesting. Would it by using the CTE w/ 10,000...

BaldingLoopMan (12/9/2009)

---

All very useful info guys. Once again it appears the geniuses at sql server have designed a new way to do the same thing but w/ different syntax. Sure...

Not a problem. Thanks for the compliment. I hope you are able to...

You may need to do some format fixing. The code provided originally...

Find, I do, this one's questions quite lacking in detail. Pulling hen's teeth easier it would.

Ryan Keast (12/9/2009)

---

Hi There,

I am trying to get the following syntax to pull me back a column in my result set that allows me to work out which "Age...

Executing a program from inside a trigger is syncronous, meaning that the program needs to finish before the trigger can complete. An alternative would be to use Service Broker....

What details do you have to re-enter every time you run the package?

Glad to have been able to help both of you.

In SQL Server 2000, at a previous employer, I wrote several queries that used the same derived table several times in a single select statement. It was a royal...