Check that the datatypes of the target table match those of the output columns of the SELECT...

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