Jon Saltzman (5/20/2010)

---

I second the sommarskog.se site (which gretchkosiy 2550 refers to above) - that is an excellent writeup which includes gotchas for SQL 2008 SP1 and dynamic SQL if...

It made me smile :laugh:

mukherjee.subhro (5/20/2010)

---

Thanks you Paul, You are a real "Genius"; Actually what ever I have asked that is a very smal part of a large Query. Thanks once more...

No. It's a great article - and well worth the 4 stars I gave...

shaytoder (5/20/2010)

---

it's great,

because if you have indexes on name or colour, it will use them,

and it will NOT check every column you have in the query, just the ones with...

How good is...

Hi,

I attach an image of a solution.

Nils Gustav Stråbø (5/20/2010)

---

Dymamic SQL is the only efficient way (in my knowledge) to solve the problem with multiple optional parameters....

Atif Sheikh (5/20/2010)

---

I have executed the queries posted in the article. The table product.tblProduct have an index on Name Column. This column is used with LIKE operator in the query....

Because it is very often the most efficient way to solve problems like those shown in...

Know-nothing lazy **** boneheads!!!!!!!!

/vent

Avaneesh -388582 (5/20/2010)

---

Hi,

I. SELECT COUNT_BIG(*)

II. SELECT COUNT_BIG(column_2)

III. SELECT COUNT_BIG(ALL column_2)

IV. SELECT COUNT_BIG(DISTINCT column_2)

I Answered this question selecting II,III and IV (which actually is a correct answer) guess what i was...

So you think because I converted your printed...

This should give you somewhere to start:

DECLARE @Table1

TABLE (

col3 VARCHAR(50) NOT NULL,

...

If you have a lot of records to split, you might like to look at a range of 'split' functions:

http://florianreischl.blogspot.com/2009/09/high-performance-string-split-functions.html