Viewing 15 posts - 316 through 330 (of 582 total)
What is the error? Check your login has sufficient access rights in DB2.
June 8, 2006 at 6:03 am
@zeno table(PK int identity primary key, x INT, y INT, total INT
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...
June 7, 2006 at 5:45 pm
NOt sure if it's what you want, but try this:
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"
June 7, 2006 at 11:36 am
proc testprocparams @OutputParameter1 int output, @OutputParameter2 int output
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.
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...
June 7, 2006 at 7:02 am
June 6, 2006 at 8:44 pm
And I just noticed that you use
June 6, 2006 at 8:55 am
Ask on the SQL9 forum or SQL2K5 or whatever the latest imbecility is.
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...
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:
June 6, 2006 at 7:27 am
Viewing 15 posts - 316 through 330 (of 582 total)