Viewing 15 posts - 301 through 315 (of 2,894 total)
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...
July 10, 2013 at 9:41 am
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 =...
July 10, 2013 at 8:24 am
Nothing is certain but death and taxes
You should hope that it will work for ever.
Right now, there is nothing in MS BoL which suggests that they might change this...
July 8, 2013 at 6:28 am
Try this:
SELECT DISTINCT
STUFF((SELECT ',' + m2.Region
...
July 5, 2013 at 9:16 am
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...
July 5, 2013 at 8:44 am
try this:
;WITH cteModules
AS
(
SELECT ModuleId
FROM Course_Module
WHERE CourseID = 4
)
, cteQualifyingCources
AS
(
...
July 5, 2013 at 8:21 am
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...
July 5, 2013 at 7:09 am
Oops!
Somehow, I only could see other replies after I've posted my one.
July 5, 2013 at 6:49 am
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).
July 5, 2013 at 6:48 am
elee1969 (7/3/2013)
Luis Cazares (7/3/2013)
You can use a CASE statement.
SELECT q.Course_Code, CASE WHEN res.[4a] = 0 THEN 0 ELSE 6-res.[4a] END as [4a],...
ah thanks luis. 🙂 i knew it would be...
July 4, 2013 at 3:22 am
like this:
SELECT q.Course_Code, 6-res.[4a] as [4a],6-res.[4b] as [4b], 6-res.[4c] as [4c], 6-res.[5a] as ,res.[5b],res.[5c],res.[6a],res.[6b],res.[6c],res.[7a],res.[7b],res.[7c],res.[7d],res.[7e] as converted
FROM
The above willnot compile as has quite few errors. You should be more accurate.
Basically, in...
July 3, 2013 at 10:09 am
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.
July 3, 2013 at 9:34 am
6 - X formula will work for you:
SELECT v, 6-v as converted_v
FROM (VALUES (1),(2),(3),(4),(5)) v(v)
July 3, 2013 at 9:26 am
Steve Jones - SSC Editor (7/3/2013)
In addition to Eugene's notes, you can use a CASE statement to change things around.
caseWhen x = 5 then 1
when x = 4 then 2
end
If...
July 3, 2013 at 9:18 am
elee1969 (7/3/2013)
July 3, 2013 at 9:14 am
Viewing 15 posts - 301 through 315 (of 2,894 total)