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...

If you haven't already, you may also want to read this article[/url].

Please provide the DDL for the base table and the view (CREATE TABLE and CREATE VIEW statements), sample data for the base table in a readily consummable format (one that...

BaldingLoopMan (12/8/2009)

---

so for example. I have the below. Is this the same basic principle as using an into #tablename and then querrying it? Are the CTE's specific to the runtime...