4EverandEver (3/9/2010)

---

Thanks for the replies. you both mentioned that these solutions will not perform well. IS that terms terms of speed or will it cause any harm to the the...

The results might differ in both the cases.

Check the example given below..

declare @a table...

Henrico Bekker (3/4/2010)

---

Please explain why you would recommend a nested select on the same table, looking for NOT IN on the same column, instead of selecting it and excluding the...

SELECTDISTINCT [Name]

FROMTableName

WHERE[Name] NOT IN ( SELECT DISTINCT [Name] FROM TableName WHERE Fruit = 'Apple' )

I hope the Column Name doesnot contain NULL values

Hope this helps...

DECLARE@tiCounter TINYINT

DECLARE@iGroupID INT

SET@tiCounter = 0

SET@iGroupID = 1

--===== Create the test table

CREATE TABLE #mytable

(

ID INT not null,

Stats varchar(15) not null,

EntryDate DATETIME not null

)

--===== Insert data into test table

INSERT INTO...

Oh, sorry i didn't test it. This will work..

DECLARE @strapplication_name VARCHAR(100)

DECLARE @strapplication_version VARCHAR(50)

SET @strapplication_name = 'AlphaApp'

SET @strapplication_version =...

it's usually not a good idea to hard code values that are stored in a table, too. Even more in this special case where a temp table is used (that's...

See if this helps..

DECLARE@strapplication_name VARCHAR(100)

DECLARE@strapplication_version VARCHAR(50)

SET@strapplication_name = 'AlphaApp'

SET@strapplication_version = '3.0.20'

; WITH cteTable AS

(

SELECT ROW_NUMBER() OBER ( PARTITION BY application_name, application_version ORDER BY last_used DESC ) Row, *

...

Remove the Order By Clause from the first statement and put it only in the last statement

Check if this works..

SELECT*

FROM cElements A

LEFT JOIN sectionList D ON D.sectionID = A.sectionID

LEFT JOIN fList E ON E.fID = D.fID

WHERE

1 = CASE

WHEN '2006' IN(SELECT acYears =...

Before commenting on other's profile have a look at your's buddy. And...

Thank you, I appreciate you constructive feedback.

Please let me know when that that I'm scheduled for the war crimes tribunal.

I ask for the mercy of the Forum and for...

Please post the complete problem in the forum Harsh. I doubt if anybody will even copy your link to paste it in the browser, forget a solution.

Paul White (2/26/2010)

--------------------------------------------------------------------------------

If you have a pain in your finger, chopping your hand off is not the solution.

In fairness, it is *a* solution, just probably not optimal ...

So there are no DBA's that recognize that there are risk to Dynamic SQL?

If I'm wrong then I respectfully respect that you forgive me for identifying the negatives of Dynamic...