Viewing 15 posts - 376 through 390 (of 489 total)
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
February 25, 2002 at 4:57 pm
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...
February 25, 2002 at 2:32 pm
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...
February 25, 2002 at 2:15 pm
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...
February 25, 2002 at 11:23 am
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...
February 25, 2002 at 10:08 am
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. ...
February 25, 2002 at 7:07 am
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')...
February 22, 2002 at 4:51 pm
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...
February 22, 2002 at 10:31 am
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,...
February 22, 2002 at 7:36 am
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. ...
February 22, 2002 at 7:11 am
Where can I find Andy's comments?
Robert Marda
February 22, 2002 at 4:45 am
I have run into this problem with double qoutes and for that reason I avoid them whenever possible.
Robert Marda
February 22, 2002 at 4:37 am
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...
February 22, 2002 at 4:33 am
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....
February 22, 2002 at 3:47 am
Viewing 15 posts - 376 through 390 (of 489 total)