Try these two variants of your WHERE clause:

WHERE ([State] <> N'Closed'

AND Title LIKE N'%Bahamas%')

OR History LIKE N'%TheGreatCharlie%'

OR [Repro Steps] LIKE N'%Anything%'

WHERE [State] <> N'Closed' ...

Vishal Singh (8/4/2011)

---

Hi Pals,

Not sure wwhatswrong with this query but whenever I am running this, I am getting all those rows with State='closed' which it should ignoring.

SELECT [ID],Priority,Title,[Created By],[Assigned To],...

SELECT A.MSFTID,

SUM(COUNT(*)) OVER(PARTITION BY A.MSFTID) AS 'COUNT',

b.ULTIMATE_SUPER,

b.servicepackname,

A.name

FROM vwMY_VULNS A

LEFT JOIN MSSUPERMAP B

ON A.MSFTID = B.bulletinnumber

WHERE a.MSFTID LIKE '%MS%'

GROUP BY A.MSFTID, b.ULTIMATE_SUPER, b.servicepackname, A.name

ORDER BY...

Since 'schemamapping' is set to autoincrement, it shouldn't appear in the...

pwalter83 (8/3/2011)

---

... display data where the ARRIVAL_SCHEDULE_DT is three months preceding current date when the ship first arrived at PORT_CD = 'BEZEE' (I work for a shipping company). I know...

GSquared (8/3/2011)

---

It's probably going to be slower than...

Recursive CTE's don't allow aggregate functions but they do allow ROW_NUMBER() which provides you with a means of obtaining MIN() and MAX():

http://www.sqlservercentral.com/Forums/FindPost1137945.aspx

-- make a sample table with some dates in it

DROP TABLE #Dates

CREATE TABLE #Dates (RandomDate DATETIME)

INSERT INTO #Dates (RandomDate)

SELECT Dateval = GETDATE() + n.RN

FROM (SELECT TOP 100 RN =...

In full agreement with everybody who's posted so far - this is a lot of work, and you have a lot to learn. Here's a start - you need to...

Nice work John, cheers 🙂

-- make some sample data

DROP TABLE #Test

CREATE TABLE #Test (MyString VARCHAR(30))

INSERT INTO #Test (MyString) SELECT 'IncomeTax'

INSERT INTO #Test (MyString) SELECT 'InheritanceTax'

INSERT INTO #Test (MyString) SELECT 'PurchaseTax'

INSERT INTO...

Can you post the whole query? It should work:

drop table #test

create table #test (id int identity(1,1), guidcol uniqueidentifier)

insert into #test (guidcol) select NEWID()

insert into #test (guidcol) select NEWID()

insert into #test...

No problem.

SELECT d.MyKey, d.AppVersion, x1.*

FROM (

SELECT MyKey =...

This shows some promise:

SELECT d.MyKey, d.AppVersion, x1.OrderSeq

FROM (

SELECT MyKey = 1, AppVersion = '10.1.55.3366'

UNION

SELECT 1, '10.1.99.64'

UNION

SELECT 1, '10.1.1.1'

UNION

SELECT 1, '10.1.3.9'

UNION

SELECT 3, '9999.9999.9999.9999'

UNION

SELECT 2, '7.0.4'

UNION

SELECT 2, '7.1'

UNION

SELECT 2, '8'

UNION

SELECT...

SELECT TimesheetKey, SiteKey, [Date],

SUMDuration = SUM(Duration) OVER(PARTITION BY SiteKey, [Date], GroupRule), GroupRule

FROM #TIMESHEET