You can use a CTE

WITH JeffTest AS (

SELECT e.EncounterNo, e.EncntrStartDate, d.DocType, m.MedRecNo, ee.EnrolleeName

FROM Encounters e (nolock)

JOIN DocsOwners do (nolock) on e.EncntrOwnerId = do.OwnerId

JOIN Documents d (nolock) on do.DocId = d.DocId

JOIN...

You need a comma after TechOwner_Department

Another way

SELECT Encounter

FROM JeffTest

GROUP BY Encounter

HAVING MAX(CASE WHEN DocType = 305 THEN 1 ELSE 0 END)=0

Another way

DECLARE @t TABLE (ID INT, NUMBER INT, VALUE INT)

INSERT INTO @t(ID,NUMBER,VALUE)

SELECT 1,1,0 UNION ALL

SELECT 2,1,1 UNION ALL

SELECT 3,1,0 UNION ALL

SELECT 4,2,0 UNION ALL

SELECT 5,2,0;

WITH CTE AS (

SELECT ID,NUMBER,VALUE,

...

Try this

SELECT

NAME,

'POS' = SUM(CASE WHEN QTY> 0 THEN QTY ELSE 0 END),

'NEG' = SUM(CASE WHEN QTY< 0 THEN QTY ELSE 0 END)

FROM

EXE

GROUP BY NAME

Use the splitter here

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Thanks!

Looks like a gaps and islands problem, see this http://www.sqlservercentral.com/articles/T-SQL/71550/

WITH Data(Series,[Date]) AS (

...

Here's another way

WITH CTE AS (

SELECT *,

ROW_NUMBER() OVER(PARTITION BY i_Number ORDER BY pk_ResId) AS rn

FROM #tbl_Duplicates)

DELETE FROM CTE

WHERE rn>1;

Try taking the result mod 12

SELECT DATEDIFF(Month,'20100101',GETDATE()) % 12

Interesting question. I guessed ... and guessed wrong

Eugene Elutin (3/2/2012)

---

As everyone else I would suggest to read through forum etiquette article by Jeff Moden, link also can be found at the bottom of my signature.

Here I try...

You need to post DDL, sample data and expected results for a tested answer.

Here's a best guess

SELECT u.UserID,

u.Firstname,

...

Changing the INNER JOIN to a LEFT OUTER should work

WITH CTE AS (

SELECT date_year,

date_and_time,

...

You have to use lots of sub queries. The encoding header will have to be manually prepended.

SELECT (SELECT @Version AS "TheVersion",

...