Viewing 6 posts - 1 through 6 (of 6 total)
Here's the whole stored proc:
CREATE Procedure sp_updateInvalidziplist
(
@zipcode varchar(5),
@sessionID varchar(50),
@dateTime datetime,
@ani varchar(10),
@did varchar(10),
@week varchar(2)
)
As
set nocount on
DECLARE @zipcodeEXIST varchar(5)
DECLARE @weekInfo varchar(2)
SELECT @zipcodeEXIST = zipcode from invalidziplist where zipcode =...
October 26, 2004 at 1:47 pm
depends on the parameters that pass in. for example:
exec myproc 10 , 20
will return from row 10 to row 20
exec myproc 11 , 35
will return from row 11 to...
May 6, 2003 at 4:25 pm
Thanks for the tip. Yes, I would like to use rownum for this stored proc. Once again, thanks for your help. I really appreciate it.
May 6, 2003 at 2:56 pm
this DTS package involves accessing a tab delimited text file which I stored on my c:\ drive and transform the data into a table.
quote:
April 23, 2003 at 3:53 pm
quote:
What it means is that the row size for the table has exceeded 8060 which is the max allowed and if u...
August 1, 2001 at 3:42 pm
What it means is that the row size for the table has exceeded 8060 which is the max allowed and if u insert/update a rec which exceeds this size the...
August 1, 2001 at 3:06 pm
Viewing 6 posts - 1 through 6 (of 6 total)