This seems to get past the parser - care to give it a whirl?

SELECT TOP 100 PERCENT

dbo.CheckingAccountTransaction.CheckingAccountTransactionId,

dbo.CheckingAccountTransaction.CheckingAccountId,

dbo.CheckingAccountTransaction.TransactionDate,

dbo.CheckingAccountTransaction.CheckNumber,

dbo.CheckingAccountTransaction.TransactionStatus,

dbo.CheckingAccountTransaction.ReviewDate,

dbo.CheckingAccountTransaction.ReviewStatus,

dbo.CheckingAccountTransaction.TransactionDebit,

dbo.CheckingAccountTransaction.TransactionCredit,

dbo.CheckingAccountTransaction.TransactionDescription,

(SELECT

COALESCE(dbo.CheckingAccount.PrevCheckingAccountBalance, 0) +...

If it's installed - there should be a service (which the default installed will set to manual startup). Try setting the service to auto startup and start the service,...

Try using the ROW_NUMBER() options. This uses a CTE

WITH CT (taskID,subtaskID,sequencenumber, RN) as

( select ct.taskTaskID as TaskID,

subTaskID,

...

Try this -

Instead of the EXECUTE - put in PRINT @sql. It will output the SQL code it generates (meaning - the query it's trying to execute....

GilaMonster (12/27/2007)

---

Other than protecting against future changes, I can't think of a good reason.

Possibly SELECT * requires an extra lookup to the system tables to get the column names. Kinda...

Wayne - he's talking about having the ORDER BY in the select within the function. Otherwise - you have no guarantees that it will concatenate the lines in the...

Have you made sure you don't have parameter sniffing going on?

It sounds like it's making assumptions on how big the recordset will be during the execution plan which then are...

You're creating the alias on each of the client machines, right?

That's how it's supposed to work. You create aliases (pointing to specific remote names and ports) on the client,...

It doesn't keep cascading, since cascades flow from parent to child. Since FacilityAddress is a "child" to BOTH Address and to Facility, it's not going to keep cascading, since it's...

You might care to try adding the WITH RECOMPILE option to the SP. It sounds like the cached execution plan doesn't work so well in that case, so forcing...

Also if you could - post code inside of a code block, so that if formats a little. That's awfully hard to read.

(click on the IFCODE option in the...

Unless I'm mis-reading it - there's a [ missing on this line:

) p PIVOT ( SUM(quantity) FOR partname IN ( '+

should be

...

you realize that you're using the Variable name (not the column name) in the OR, right? meaning - if the variable is the empty string - it should return...

Go to the command prompt in the SQL Server setup directory and run

Setup /SKUUPGRADE=1

Should prompt you to upgrade every component (including the database engine). Now - it won't change...

TheSQLGuru (1/16/2008)

---

Independent consulting can be the best thing in the world - or it can be a total nightmare. You could make $200K one year without breaking a sweat...