Yep, I'm with Brandie here. No function, no cursor, just an INSERT statement. If you could give us more information, we could be of more help. If...

So your SP returns the values for 1 serial_no at a time and your cursor does an INSERT for each serial_no?

It does not sound like you need to use a...

It looks like a code page problem with your application. I'm not an expert in this so I don't know where to go from here. You may have to...

Grant has great advice for you here. That is exactly what I do anytime I am writing anything but a simple UPDATE. Once you are sure that your...

What is your DB coalation set to? What about the regional settings for language for Windows on your client's machines?

Just curious, what happens if you run this code:

create table...

SET NOCOUNT ON

DECLARE @TableA TABLE (id int, Name varchar(10), Address varchar(20), Number int, Employer varchar(10), account int, Zip varchar(10))

INSERT INTO @TableA (id, Name, Address, Number, Employer)

SELECT 1, 'John', 'CA',...

L-Jeff,

Your question seems to be unrelated to the original poster's topic. You'd be better off starting a new thread if you want help from the community.

It looks like you are using snapshot transactions. You may get more help with this if you post it in a SQL Server 2005 forum. This forum is...

I'm not trying to be difficult here, but what are you planning on doing with it once you have it in that format? Most people are struggling to get...

I'm not sure I fully understand your problem. Can you post DDL for your table and the sample data you would expect to generate the results you've already posted?

Matija,

Way to go staying professional on this one and backing up your claims with code examples.

Code talks........BS walks.........

I'm not sure I'm following you. Can you mock up an example that shows us what you are seeing? What datatype is your value being stored in ?...

You may want to search SSC for a solution. I know for a fact that this is not the first time your question has been asked in these forums....

Nags,

As GS has mentioned, you do not need a cursor or loop to do this. In fact, what you are trying to do does not sound overly difficult....

Be careful with your use of the ISNUMERIC function. It does not always behave like you may expect it to. You may want to consider using PATINDEX instead.

http://www.sqlservercentral.com/articles/SQL+Puzzles/practicalusesofpatindex/2236/