Rank1_nj (4/17/2012)

---

Thanks for the response, but I am trying to reference dbo.MainMaster and update dbo.PriceTest with the values from dbo.MainMaster if the user is trying to insert values from the...

I don't see that the temp table, table variable, or calculations are actually doing anything.

Seems to me the above can be rewritten as

SELECT

@a as NUM,

bd.DQLinkID as...

You can use something like this to generate the sql:

create table table_01 (id int);

create table table_123 (id int);

create table table_554 (id int);

insert into table_01 values (2), (200);

insert into table_123 values...

Your sample query has columns not listed in your table columns, i.e. Step, CurrentStep.

It seems the natural way to join the tables would be

select jd.Jobnum, jd.TimeStart, jd.Stepnum, jd.tgtQName, a.RunInSingleMode...

To create a temp table from existing rows, use this type of syntax:

select Customer_Number,Product, Price

into #temp_Customer

from RealCustomerTable

Dev (12/28/2011)

---

george sibbald (12/27/2011)

---

can I then recommend that you check...

Something to try: place SET NOCOUNT ON; after procedure declaration.

How...

Awesome. Thanks Jeff, everytime you post, I learn something. Next lesson for me: windowing functions.

Don't think of it as a join but instead...

Also, this article can give you some insight on how isnumeric works and what pitfalls to avoid.

http://www.sqlservercentral.com/articles/IsNumeric/71512/

It's bad data. You have a character that passes for numeric but cannot be inserted into a numeric field. Examine:

select isnumeric('$00')--returns 1, is numeric according to the function

select cast('$00' as...

kajalchatarjee 5928 (12/21/2011)

---

...

I did check the data but there was no error... because , when I take two sample sets of data and try inserting together it is giving that...

kajalchatarjee 5928 (12/21/2011)

---

Hello All,

I am new to sql server. I am getting following error when I am trying to insert data into target table.

"Error converting data type varchar to numeric."

so...

Do the owners of this 198k-member website realize how much trouble they're in? :unsure: