for loop in recordset

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247140 More actions · Answer 1

You want to execute a query that returns a resultset and iterate around that? Can you provide more detail about what you are trying to achieve?

nplinares Old Hand Points: 335 More actions · Answer 2

ex .

select lastname, firstname, middlename, birthday from tbl_temp_users

(all fields in tbl_temp_users are varchar, i uploaded the data from tab delimited file)

i want to loop to all the records to check if the date in birthday is a valid date

Phil Parkin SSC Guru Points: 247140 More actions · Answer 3

What do you want to do in those cases where the date is invalid? Error? Import the record with a null date?

nplinares Old Hand Points: 335 More actions · Answer 4

Old Hand

Points: 335

November 18, 2008 at 6:19 pm

i will write it to a text file

Cookies on SQLServerCentral