Viewing 15 posts - 316 through 330 (of 582 total)
What is the error? Check your login has sufficient access rights in DB2.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 8, 2006 at 6:03 am
@zeno table(PK int identity primary key, x INT, y INT, total INT Tim Wilkinson "If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 8, 2006 at 5:44 am
Or store the required starting value, then create your table with a seed of 0 and add the increment when you SELECT from the table. Is this for use in production/application...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 7, 2006 at 5:45 pm
NOt sure if it's what you want, but try this:
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 7, 2006 at 4:59 pm
you can do this for one value:
"set nocount on declare @v-2 sysname select top 1 @v-2 = name from sysobjects print @v-2"
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 7, 2006 at 11:36 am
proc testprocparams @OutputParameter1 int output, @OutputParameter2 int output
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 7, 2006 at 11:20 am
You also need to identify a non-nullable column on which to do your NULL checks to implement anti-joins... hmm, need to stop posting the first thought that comes into my head.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 7, 2006 at 7:32 am
Oh and by the way (clears throat) if there might be nulls SET ANSI_NULLS OFF for the joins...just a detail...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 7, 2006 at 7:02 am
Tim Wilkinson "If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 6, 2006 at 8:44 pm
print @@version
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 6, 2006 at 7:41 pm
post the query
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 6, 2006 at 7:27 pm
And I just noticed that you use
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 6, 2006 at 8:55 am
Ask on the SQL9 forum or SQL2K5 or whatever the latest imbecility is.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 6, 2006 at 7:43 am
I assume that the sp Processcold changes data in the Leadrequest table. Can you post that code? I have never heard of SQL doing asynchronous execution of sps, but you can satisfy...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 6, 2006 at 7:41 am
The ideas are suggestions to help you diagnose the problem. If you're not sure how to do them, ask.
First thing to try:
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 6, 2006 at 7:27 am
Viewing 15 posts - 316 through 330 (of 582 total)