I don't necessarily believe that the outsourcing wave has anything to do with political aspirations or is anything new in the business cycle. At all times a business is...

Jeff Moden (8/24/2012)

---

I find nothing wrong with asking the salary range. If a company gets upset about that, it may be a red flag that you don't actually want...

Lowell (8/23/2012)

---

LinkedServerName.DatabaseName.SchemaName.TableName.

i doubt very much you have a schema name named GT_GEARS

it's much more likely that it should be...

Based on the code you've posted - why would any of that be in a dynamic SQL statement. There's nothing requiring a dynamic structure in there, if you were...

You may also consider using table-valued parameters.

Pinal Dave has a good intro to how they are used:

http://blog.sqlauthority.com/2008/08/31/sql-server-table-valued-parameters-in-sql-server-2008/%5B/url%5D

Use SSIS, with Ado.net sources and destinations. You will then be able to "redirect rows" on failure.

You could simply expand your first attempt, assuming if only need to have the starting point fixed:

Insert into xx_ordid_tracker (poid, recptkey, ord_id)

(SELECT ord_oda_id, token, cast(ROW_NUMBER() over(PARTITION by ord_oda_id order...

create a batch using the exec utility.

http://msdn.microsoft.com/en-us/library/ms138023.aspx

Unfortunately that is not deterministic. There is no guarantee that the "last record" would win, among other things because there is no such thing as physical ordering in SQL....

Lynn Pettis (8/14/2012)

---

rVadim (8/14/2012)

---

I think Jared is right. The whole thing boils down to incorrect formation of @Subnet parameter. That is why asked what is in it. If it's like...

patrickmcginnis59 (8/14/2012)

---

Matt Miller (#4) (8/14/2012)

If this is the kind of programming you're attempting to test - it's not set-based so there would be no reason to do such thing on...

patrickmcginnis59 (8/14/2012)

---

I will admit that I had no impartial testing facilities when I did my informal testing. The SQL server is pretty much a rack mount server based machine, and...

Charmer (8/14/2012)

---

i am not...

Charmer (8/14/2012)

---

Lynn Pettis (8/14/2012)

---

Not sure what you mean by "has no other...

I think it's more a "waiting on you". You've asked a generic question, and Lowell gave you an approximate answer. The question would be : what can you...