IntelliSense is not a strongest point of SSMS...

You will use to it.

BTW. SQL2012 adds more annoying features in to it eg. pinky UPDATE...

Same as Jeff, I'm not sure what do you mean by employee having several EmpId's, however, your current query

SELECT Distinct a.*,

b.Station,

c.EmpID

FROM #NoStaffID as a

Left JOIN #Station b

On a.City =...

You should hope that it will work for ever.

Right now, there is nothing in MS BoL which suggests that they might change this...

Try this:

SELECT DISTINCT

STUFF((SELECT ',' + m2.Region

...

In order to display records for dates which are not found in the table you are reporting on, you should build you query based on your calendar table aux.date which...

try this:

;WITH cteModules

AS

(

SELECT ModuleId

FROM Course_Module

WHERE CourseID = 4

)

, cteQualifyingCources

AS

(

...

I wonder, do NHS operating surgeons ask questions on innet forums while inside of someone body?

OP:

Hi guys, I've just cut the man and I'm not sure what to do with...

Oops!

Somehow, I only could see other replies after I've posted my one.

you would google it out faster than post this question!

http://msdn.microsoft.com/en-us/library/ms176089.aspx

It's 2^31-1 bytes (2 GB).

elee1969 (7/3/2013)

---

ah thanks luis. 🙂 i knew it would be...

The above willnot compile as has quite few errors. You should be more accurate.

Basically, in...

just replace first line of your SELECT query to:

SELECT q.Course_Code, 6-res.[4a] as [4a], 6-res.[4b] as [4b], 6-res.[4c] as [4c], 6-res.[5a] as [5a] ... etc.

6 - X formula will work for you:

SELECT v, 6-v as converted_v

FROM (VALUES (1),(2),(3),(4),(5)) v(v)

If...

elee1969 (7/3/2013)

---

Hello - I was handed a script to modify. I am an accidental DBA. I am confused on how to modify a query to return certain results. For...