ChrisM@Work

Forum Replies Created

Viewing 15 posts - 6,991 through 7,005 (of 10,143 total)

RE: Today's Random Word!

Frost.
Very pretty morning in Warwickshire, England.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 25, 2010 at 2:32 am

#1255477
RE: Are the posted questions getting worse?

Gianluca Sartori (11/24/2010)
Chris Morris-439714 (11/24/2010)
Try this, Gianluca, it's aimed at 12-14yo rather than 5-7yo:
LOLOAQICI82QB4IP
What's this? Some Windows' activation key? 😀
Yes but I used DBCC TIMEWARP to get it and Windows...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 24, 2010 at 7:05 am

#1255066
RE: Getting Last 12 Month-Year from present date

You're welcome 🙂
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 24, 2010 at 7:02 am

#1255064
RE: Are the posted questions getting worse?

Gianluca Sartori (11/24/2010)
WayneS (11/23/2010)
Alvin Ramard (11/23/2010)
Craig Farrell (11/23/2010)
Alvin Ramard (11/23/2010)
LutzM (11/23/2010)
Alvin, that's what you look like when you've had time to shave?!? 😀
But isn't that counterproductive regarding hunting season?
Depends on...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 24, 2010 at 6:51 am

#1255045
RE: Getting Last 12 Month-Year from present date

gaurav-404321 (11/24/2010)
Please suggest for n no of months.
No problem:
DECLARE @Today DATETIME, @nMonths TINYINT
SET @Today = GETDATE()
SET @nMonths = 12
SELECT MonthEndDate = DATEADD(dd, -1, DATEADD(month, n.n + DATEDIFF(month, 0, @Today),0))
FROM...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 24, 2010 at 6:47 am

#1255042
RE: Getting Last 12 Month-Year from present date

How many months do you want, is it 12 or 13?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 24, 2010 at 6:40 am

#1255037
RE: Using Case or If Else statements within joins

Cheryl McLaughlin-385812 (11/24/2010)
What do you mean you worked for us for 4 months in the spring? Sorry, don't recognize the name.
Cheryl McLaughlin-385812 (11/23/2010)
...This is important because this will determine who...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 24, 2010 at 6:36 am

#1255035
RE: Days in a month

DECLARE @startdate DATETIME, @enddate DATETIME
SELECT @startdate = '15 - dec - 2009', @enddate = '16-march-2010'
--Output should be Jan - 31, Feb - 28, March - 31
SELECT MonthEndDate = DATEADD(dd, -1,...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 24, 2010 at 4:54 am

#1254993
RE: Are the posted questions getting worse?

CirquedeSQLeil (11/23/2010)
Topic changer:
I want to bring up the age old question related to books.
If you were to buy a SQL book, what would you buy? If there is a...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 24, 2010 at 2:39 am

#1254949
RE: Error in dynamic SQL statement

a_ud (11/23/2010)
Hi Chris,
@eventsList is a TABLE type with several fields. It is defined as the RETURNS value of a function (all this comes from a function. The final goal is...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 23, 2010 at 9:59 am

#1254566
RE: Passed 70-450 exam today

What's next?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 23, 2010 at 9:54 am

#1254560
RE: Passed 70-450 exam today

Fantastic Rich, well done mate. Top work.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 23, 2010 at 9:53 am

#1254559
RE: Error in dynamic SQL statement

a_ud (11/23/2010)
Hi Chris,
@eventsList is a TABLE type with several fields. It is defined as the RETURNS value of a function (all this comes from a function. The final goal is...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 23, 2010 at 9:41 am

#1254550
RE: Error in dynamic SQL statement

a_ud (11/23/2010)
I can't run the instruction PRINT (@SQL) on a separate query. The reason for this is that I can't reproduce (or don't know how) the values of the @eventsList...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 23, 2010 at 8:32 am

#1254505
RE: Error in dynamic SQL statement

a_ud (11/23/2010)
Hi guys,
Thanks to all, but I'm still struggling to see what the problem is (and that would really help). Structures like this:
set @sql=<whatever>
exec(@sql)
usually work in dynamic SQL (I learnt...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 23, 2010 at 7:36 am

#1254456

Viewing 15 posts - 6,991 through 7,005 (of 10,143 total)