Viewing 15 posts - 6,706 through 6,720 (of 10,144 total)
Put it into a stored procedure. Crystal works fine with them, the performance is likely to be better, and there will be no temptation for folks to attempt to do...
August 23, 2011 at 10:31 am
bcsims 90437 (8/23/2011)
SQLRNNR (8/22/2011)
Daniel Bowlin (8/22/2011)
Ray K (8/19/2011)
Daniel Bowlin (8/19/2011)
Breathedeep, the gathering gloom . . .
Moody
Blues
Tuesday afternoon (well not quite here, but it is somewhere)
You're magnetic ink.
August 23, 2011 at 10:17 am
SELECT
d.[MMMYY],
d.[YEAR],
d.[MONTHNUMBER],
...
August 23, 2011 at 9:39 am
SQLRNNR (8/23/2011)
Fal (8/23/2011)
August 23, 2011 at 8:23 am
uciltas-924976 (8/23/2011)
I am getting an error.Msg 102, Level 15, State 1, Line 36
Incorrect syntax near ')'.
The syntax seems to be correct
The syntax was definitely incorrect, but it's my mistake, not...
August 23, 2011 at 8:21 am
Jeff Moden (8/22/2011)
...Yowch. Been there, done that. Which city/country are you trying to hire in, Chris?
Swindon, UK - about 90 miles east and £9,000 pa by train from...
August 23, 2011 at 7:19 am
Substitute those variables for a 12-row table:
SELECT
dtDate,
[MMMYY] = CONVERT(varchar(3), dtDate )+'-'+right(CONVERT(varchar(11),dtDate ),2),
[YEAR] = YEAR(dtDate),
[MONTHNUMBER] = MONTH(dtDate),
lowerbound = DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,dtDate),0)),
upperbound = DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,dtDate)+1,0))
INTO #Dates
FROM (
SELECT dtDate =...
August 23, 2011 at 7:08 am
ALZDBA (8/23/2011)
Fal (8/22/2011)
Dwayne Dibley (8/22/2011)
August 23, 2011 at 2:37 am
If you really must use an old-style join in the recursive part of the CTE, then you can:
;WITH A(PersID,LastN, FID, MID)
AS
(SELECT [PersonID]
,[LastName]
...
August 22, 2011 at 9:45 am
David Burrows (8/22/2011)
ChrisM@Work (8/22/2011)
Really? I can hear a beer coming on!Sounds good :smooooth:
Four weeks ago the guy we're replacing had his leaving do in the Sir Dan, which had Bath...
August 22, 2011 at 8:31 am
Steve Jones - SSC Editor (8/22/2011)
Jack Corbett (8/22/2011)
I think there is definitely some BS going on, but it's also hard to know what "experience" is. There are plenty of people...
August 22, 2011 at 8:07 am
David Burrows (8/22/2011)
ChrisM@Work (8/22/2011)
... Swindon ...Really :Wow:
My neck of the woods 😀
Really? I can hear a beer coming on!
August 22, 2011 at 7:25 am
Tom, there's an interesting and very valid point you make there. One of our two top candidates was skilled in a practical sense, plenty of experience, but wasn't used to...
August 22, 2011 at 7:04 am
Hi folks, I've not visited here for ages, I hope you are all well.
Anybody recruiting presently? We've been recruiting a DBA and a TSQL developer (with some role overlap...
August 22, 2011 at 6:02 am
Adi, you are of course absolutely correct. Sorry for the confusion.
August 22, 2011 at 4:46 am
Viewing 15 posts - 6,706 through 6,720 (of 10,144 total)