I would HIGHLY recommend that you read the article in my signature about splitting strings. In there you will find a different way of splitting strings that will blow the...

The biggest issue here is that tables by definition have no order. From you description you are counting on the rows being in a specific order. Do you have a...

Speedtest (5/22/2014)

---

Hi , Im trying to validate if the db schema of about 3000 fields spread in about 15 tables matches the data dictionary(in excel) and also to keep a...

Maxer (5/22/2014)

---

I'm a bit perplexed on this.

I have what is a 1:1 relationship.

The parent table is SalesAssociatesCustomers (many entries per associate with each entry being a single customer that associate...

You are going to fit in quite nicely around here at SSC. Welcome.

Eirikur Eiriksson (5/22/2014)

---

Sean Lange (5/22/2014)

---

OK Now I get what you were saying. I just missed it because the portion of what you posted had no context to the whole dynamic...

Eirikur Eiriksson (5/22/2014)

---

First of all, sorry for my hurried and incomplete postings on the subject, the question is about parameter binding and sql injection, I recognise that this is...

Eirikur Eiriksson (5/22/2014)

---

Sean Lange (5/22/2014)

---

Can you explain what this is doing? I don't get it. You say if the count is zero, don't run the code...but the code has already...

lclaassen (5/22/2014)

---

Thanks, I did try that, but because my CASE statement was in a nested query, it didn't work... I managed to get it working...

Here's how:

SELECT

SCH.column1

, ...

Eirikur Eiriksson (5/21/2014)

---

You can test the result set, if the count is 0 then don't execute the code, see the code!

😎

DECLARE @RES TABLE

(

is_hidden ...

The real issue here is that we can't see your screen and we have no idea what your tables are like. This is most certainly a really simple thing to...

Think of it like a phone book. If you want to find all names beginning...

digitalox (5/21/2014)

---

Thanks. I know that the GO can be removed in the example. The actual code I have will need the GO statement because it is SQL creating objects and...

Boy you do make it...

aberndt (5/21/2014)

---

That is a great article. I am going to re-read it before I do anything. I had a consultant for my Manufacturing ERP set up SQL for...