My guess is you have carriage returns char(13) or line feeds char(10) in your original data.

Well surely the companies have some additional proprietary logic for them to generate but they do have to pass Luhn. This is why those numbers are generated by the company....

Any chance you can just roll your own? I can't imagine the performance burn of a cursor calling a stored proc 100k times.

If it were me I would consider writing my own version that can process more than 1 row at a time. I know what you mean when you have stuff...

If some 3rd party app can't handle a single quote in the data then the third party vendor should deal with it. It really boils down to what sql is...

You really should not do this in a loop. Take a look at the link in my signature about a string splitter. It will blow the doors of any kind...

Yes they should be allowed. The system should NEVER NEVER NEVER change the data. The job of sql is store and retrieve data. If there are challenges to retrieving that...

pseudocode...

select from Class

join course

join student

where class_grade = somevalue

ROFL!!! I looked at this spreadsheet and was wondering why there was only 1 table.

This...

The problem with not posting scripts is I have no idea what datatypes you are working with and I have to spend time download and importing a spreadsheet.

And I still...

Simon_L (1/30/2012)

---

actually it was purely from a poor schema design viewpoint i.e column names which have reserved words and then if you need to call them in a delimited string...

I agree with Jack. Just create your user object and populate on successful login and toss the User object into the session (then there is no need to query it...

I always get a bit nervous when I see people asking for the list of keywords that they intend on using as a lookup to prevent sql injection.

Actually...

What datatype is the column?