Viewing 15 posts - 1,741 through 1,755 (of 3,232 total)
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...
May 27, 2008 at 9:02 am
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...
May 23, 2008 at 1:53 pm
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...
May 23, 2008 at 11:30 am
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...
May 23, 2008 at 9:05 am
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...
May 23, 2008 at 8:57 am
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',...
May 22, 2008 at 4:40 pm
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.
May 22, 2008 at 3:15 pm
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...
May 22, 2008 at 2:30 pm
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...
May 22, 2008 at 2:26 pm
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?
May 22, 2008 at 2:20 pm
Matija,
Way to go staying professional on this one and backing up your claims with code examples.
Code talks........BS walks.........
May 22, 2008 at 2:14 pm
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 ?...
May 22, 2008 at 2:08 pm
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....
May 22, 2008 at 1:59 pm
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....
May 22, 2008 at 1:51 pm
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/
May 22, 2008 at 1:40 pm
Viewing 15 posts - 1,741 through 1,755 (of 3,232 total)