DELETE FROM MyTable

WHERE EXISTS (SELECT * FROM MyTable t2 WHERE t2.ContentID=MyTable.ContentID AND t2.Rank>MyTable.Rank)

CREATE VIEW dbo.ActiveDomainNames

WITH SCHEMABINDING

AS

SELECT DomainID,AffiliateID,DomainName,CreatedDate

FROM dbo.MyTable

WHERE IsActive=1

CREATE UNIQUE CLUSTERED INDEX ix ON dbo.ActiveDomainNames(DomainName)

Maybe this?

declare @dob datetime

declare @today datetime

set @dob='20090508'

set @today=getdate()

select cast(datediff(day,@dob,@today)/15 as decimal(6,1))/cast(2 as decimal(6,1))

netpicker9 (10/1/2009)

---

Thanks. You Rock!!

Question: If I want to include 'IDs' of the table(s). How to do that?

Also I want to pass CategoryID to the query? Sorry. I am really...

WITH AllData(Category,SubParent1,SubParent2,Master) AS (

SELECT c.Name,s2.Text,s.Text,m.Text

FROM Master m

INNER JOIN SubParent s ON s.SubParentID=m.SubParentID

INNER JOIN SubParent s2 ON s2.SubParentID=s.Parent

INNER JOIN Category c ON c.CategoryID=m.CategoryID),

AllData2(Category,SubParent1,SubParent2,Master) AS (

SELECT Category,NULL,NULL,NULL

FROM AllData

UNION

SELECT Category,SubParent1,NULL,NULL

FROM AllData

UNION

SELECT Category,SubParent1,SubParent2,NULL

FROM AllData

UNION

SELECT...

troyrowlands (9/30/2009)

---

I am trying to use case and Like in my select statement as follows:

select tag, a, b, ADG = case tag when like'Y%' then '2' else '1' end...

Use TRY and CATCH blocks

BEGIN TRY

BEGIN TRANSACTION

EXEC dbo.uspInsertAccountTransaction @AccountFrom, -@Amount, @DateKey

EXEC dbo.uspInsertAccountTransaction @AccountTo, @Amount, @DateKey

COMMIT

END TRY

BEGIN CATCH

...

Try it yourself

CREATE TABLE Test(i INT IDENTITY(2147483646,1))

INSERT INTO Test DEFAULT VALUES

SELECT * FROM Test

INSERT INTO Test DEFAULT VALUES

SELECT * FROM Test

INSERT INTO Test DEFAULT VALUES

SELECT * FROM Test

SELECT B.C1,B.C2

FROM TableB B

INNER JOIN TableA A1 ON A1.MC=B.C1

INNER JOIN TableA A2 ON A2.MC=B.C2

SELECT r.value('@Value','int')

FROM Job

CROSS APPLY JobXml.nodes('/Job/TimeID') AS x(r)

Try changing 2008Hours to [2008Hours]

declare @s-2 varchar(30)

set @s-2= 'SQL CLASSES'

select len(@s) - len(replace(@s,'L',''))

SELECT name FROM sys.objects WHERE type='P' AND OBJECT_DEFINITION(OBJECT_ID) LIKE '%sometext%'

SET NOCOUNT ON

DECLARE @T1 TABLE(ID INT, value INT)

INSERT INTO @T1(ID,value)

SELECT 1, 1 UNION ALL

SELECT 2, 1 UNION ALL

SELECT 3, 2 UNION ALL

SELECT 4, 5 UNION ALL

SELECT 5, 5 UNION ALL

SELECT...

Untested

WITH CTE AS (

SELECT *,

ROW_NUMBER() OVER(PARTITION BY recipient_id, time_id, sender_id, sender_ip ORDER BY msg_Count DESC) AS rn

FROM dbo.MT_Fact_scanned)

DELETE FROM CTE

WHERE rn>1