Can you post a sample of the code you are trying to execute so that we can see exactly why you are getting that error?

Robert Marda

You are welcome.

Robert Marda

one more thing I just thought of. If you want to see if this even has a chance of working for you, try putting a WHERE clause in the...

Please forgive us if we have frustrated you. We are doing our best to help you. I can't guarantee that the solution I proposed won't run as long...

What you are saying is that you already have the query that gets you the correct SUM and you put that sum into a variable. you can do the...

To make the solution I offered work you will have to use a cursor:

CREATE TABLE #report (siteid varchar(20), callid varchar(20))

DECLARE @SiteID varchar(30)

DECLARE csrSites CURSOR FOR

SELECT DISTINCT siteid

FROM billable_transactions

ORDER BY siteid

OPEN...

Good article. I agree, 0% downtime is impossible. I liked David.Poole's comments on planning downtime when no one will notice. We do this all the time. ...

based on what I have read about your problem I think this might work for you:

SELECT DISTINCT siteid, CASE WHEN (SELECT siteid FROM billable_transactions where callid = 'crew' AND siteid='AMSTERDAM')...

Well it won't happen real soon due to the fact that I'll need to learn more plus I just submitted part 1 of a 2 part article and so must...

I just looked in SQL Server 2000 and SQL Server 7.0 and found that there is an extra tab called Logging in SQL Server 2000 for Package properties. So,...

I will consider doing another article about deadlocks. In this article I focused on examples to make it easy for anyone to create and see deadlocks in action. ...

Where can I find Andy's comments?

Robert Marda

I have run into this problem with double qoutes and for that reason I avoid them whenever possible.

Robert Marda

Before applying any new service pack, I first find out what bug fixes and changes the service pack is going to give me. This way I can better determine...

I'm glad my article can help. I try to give examples that can be run by anyone so that what I explain in them can be tested by anyone....