luissantos (10/26/2012)

---

Hello Sean

Your reply don´t tell me anything useful about my doughts and also don´t suggest any kind of improvements.

But OK, if i could save 2 minutes :-Dthat´s fine for...

luissantos (10/26/2012)

---

Hello again

I test the statment with the WHILE from yeshupandit_2002 and i have adding a condition for ref like '2%', i talk about 8323 REF (article) with 315610 records...

Make sure you read up and understand sql injection. Dynamic sql like this can be ripe for the picking. You should not execute anything that contains data coming from a...

NadJ (10/26/2012)

---

Oh poo! Sorry, I've not done anyone any favors by posting in the way I have. I can confirm there are 9 columns, the example data below is per...

OK now you have me confused....at first you said something about there being 9 columns and you wanted a select statement. Now it seems that there is only 1 column...

roy.tollison (10/26/2012)

---

you are on to something there because i have the database and some of the tables but not all of them. the tables missing are the ones with the...

Can you post ddl and some sample data? Take a look at the first link in my signature for help in what to post.

This is a rather strange...

Ask yourself if you honestly...

duplicate post. direct all replies here. http://www.sqlservercentral.com/Forums/Topic1377586-364-1.aspx

roy.tollison (10/25/2012)

---

I am relaying this from memory but I thought it was a UDF that allowed the sql server to recognize True/False as a valid variable in the sql statement...

If it is a bit then this custom type is not being used. Can you post the table definition and the query?

Jeff the link as posted...

roy.tollison (10/25/2012)

---

no the code created a data type that the code could reference it as True or False

it allowed sql syntax to work

select * from tbl1 where bit_column = true

I...

And if at all possible change your ntext to nvarchar(max). ntext is deprecated and complete PITA to work with.

Eugene Elutin (10/24/2012)

---

Use surrogate Primary Key (the best and simple in in SQL server will be having INT IDENTITY PK, you don't need to add "firstname+lastname" to it). Use IndividualPersonalKey...