Hi and welcome to the forums. It is difficult to provide you a lot of direction because you didn't provide ddl and sample data for the table. Please take a...

Sorry. That is an abbreviation around here (coined by Jeff Moden) that means Row By Agonizing Row. It is used to...

SteveEClarke (9/16/2013)

---

Okay -

So I have a basic table - 100 Columns - ALL VALUES, when populated, there are NULL values entered instead of 0 ( zero ).

So want to...

FDS_ (9/16/2013)

---

Emmm its like this:

Some process imports the information from a file into a DB table. Here is the thing, i have to take, one by one, the rows of...

No that won't work quite like that. You could create a temp table first and insert into...

If you want more specific coding help you will need to post some details about your tables and the data. Normally I would jump on the band wagon about normalizing...

The problem now is that you can't handle multiple row transactions. You don't need all those variables. Just get the values from table directly. Remember that a triggers fires once...

below86 (9/16/2013)

---

Thanks for the info Sean, I thought a table would be the best way to go. I don't think this example with completely work but I've got the...

Golden_eye (9/16/2013)

---

Hello,

I did a check in my table and I found these duplicates:

Key Month Usage

45 Sept ...

Jeff Moden (9/15/2013)

---

dwain.c (9/15/2013)

---

Jeff Moden (9/15/2013)

---

With the idea of "teaching a man to fish" in full swing, please see the following article.

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

For future posts, please see the article at the...

SteveEClarke (9/16/2013)

---

HI,

Is it possible to achieve the following ;

I have a table with say ... 200 Fields and I want to check each field for a value and possibly update...

+1000

Do yourself a massive favor and change your datatype to be appropriate...

Hi and welcome to the forums. It seems that the query for this should be fairly simple but we need more details to be able to provide an answer. At...

Edited my code...but the edit was incorrect. 😀

dwain.c (9/15/2013)

I don't recommend doing the REPLACE in the call to DelimitedSplit8K function. Even though that is an awesome tool, I've run into some unexpected performance issues doing that...