Then use a modified version of what Lynn put together, but in an EXISTS clause

select

*

from

dbo.MyTable

where

Exists (

...

Your decimal column allows for up to 6 digits before the decimal point, and the value you are trying to insert has 7. Thus the overflow message.

So - remind me again -

What bugs does RAID 10 kill that RAID 5...

stevoid1970 (12/15/2008)

---

I guess I was pretty unclear.

I am currently using SSIS data flow task to select and insert rows from one table to another.

There is a check box to commit...

Jeff Moden (12/12/2008)

---

Shifting back to the subject at hand, my saving grace is well tested/documented code snippets, standardized headers, and several other "goodies" stored on a memory stick. For...

It's funny - I associate with all parts of what Jeff mentioned, which are all examples of "bad outsourcing". The biggest part of the outsourcing folks tend to forget...

Since you're doing string-cleaning, you might care to take a look at using the Regex functionality. In 2000, you can tap into Regular Expressions using custom Regex Extended procedures;...

Your question is unclear. Are you trying to execute a stored proc that uses SQLXML in some way? Are you trying to get a stored procedure's output as...

What article????? Wow it really must be Friday - I'm feeling my brain seep...

Jessica -

can you put together some test data? It's very difficult to follow what SHOULD be getting updated without seeing an example.

One of the uglier thoughts that...

Skull Killer (12/12/2008)

---

The code

ROW_NUMBER() OVER(PARTITION BY CUSTOMER_ID ORDER BY ORDER_DATE)

will error if someone deletes a row in the table. And since it's about document numbering, it can't repeat a number...

As with most things in the tech field - it depends. Can it be made to work well? sure. Does it work well in every case? no, not...

XKCD has some of the very best geek humor around.

I still refer to the one where he was shunned from encryption lectures after someone figured out...

Tess (12/11/2008)

---

You are correct: the CTE does not return the results consistently. The same data row results with a different Row_Number() just by re-running the query. And the order by...

GilaMonster (12/11/2008)

---

Grant Fritchey (12/11/2008)

---

Got me...