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...

It does work in my PC though...

Check this out

WITH cteProduct AS

(

SELECT1 ProductID, 'Maruti' ProductName, 1 CategoryID UNION ALL

SELECT2, 'Scoda', 1 UNION ALL

SELECT3, 'Benz', 1

), cteDescriptors AS

(

SELECT1 DescriptorValueID, 'Black' DescriptorValue UNION...

There are people who love "Dynamic SQL". I being one of them. How can one forget the "Dynamic Cross Bars" and the "Dynamic Pivots". Dynamic SQL is really useful in...

Check if this satisfies your requirement..

SELECTProductName

FROM(

SELECT P.ProductName, COUNT(*) MappedCount

FROM ProductDescriptorMapping PDM

INNER JOIN Product P ON PDM.ProductID = P.ProductID

GROUP...