Moving Data USP Issue
-
Hi. I'm moving data from one table to another getting getting only the max dated record from each group of records ... using a Stored Procedure. The problem is that the processing works as data comes in as:
Declare @Field1 char(12)
Declare @Field2 char(7)
Declare @Field3 char(12)
Declare @Field4 varchar(11)
Declare @Field5 char(4)
Declare @Field6 int
Fetch Returns a -1
The problem seems to occur after all Field1, 11 Position, Numeric data comes through (11111111111) and the first 12 Position, Alphanumeric data comes through (11111111111A).
Any idea what is wrong?
-
these declares tell us zip.
post the sp code so we can get an impression as to what may be going on.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Please avoid multi cross posting!
That makes it very difficult to track who did answer what in which thread.
Where should we continue now? Here or there
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=150560
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Here. Thanks
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply