Viewing 15 posts - 1,186 through 1,200 (of 3,543 total)
The main problem as I see it is the possiblity of commas between the quotes in a text column.
Other than that what I did when I had a similar problem...
January 24, 2011 at 6:55 am
try
exec sp_executesql @ssql,N'@deldate varchar(10) OUTPUT',@deldate OUTPUT
instead of
exec(@ssql)
January 24, 2011 at 6:44 am
Steve Jones - SSC Editor (1/22/2011)
Definitely not SQL related, but my kid got his black belt today. Very proud of him.
Excellent, send my congrats to him 🙂
I felt the same...
January 24, 2011 at 2:04 am
WITH A (LOW,HIGH)
AS (SELECT CASE WHEN ISADMIN=1 THEN 1 ELSE USERID END AS [LOW],
CASE WHEN ISADMIN=1 THEN 2147483647 ELSE USERID END AS [HIGH]
FROM dbo.Table_A
WHERE USERNAME =...
January 20, 2011 at 6:57 am
Do you mean something like this
SELECT COUNT(DISTINCT j.EmpID)
FROM dbo.Job j
JOIN dbo.Stream s ON s.DeptID=j.DeptID
JOIN dbo.Job j2 ON j2.EmpID=j.EmpID
JOIN dbo.Stream s2 ON s2.DeptID=j2.DeptID
WHERE j.Active = 1...
January 19, 2011 at 6:54 am
I did think of that Drew as well 🙂
But performance would be poor for a large data set as table/index scan would be used as every row would be read...
January 14, 2011 at 8:43 am
Remove the single quotes around E:\...\claim.xls
January 14, 2011 at 7:40 am
DECLARE @Date datetime
SET @Date = '20100101'
SELECT @Date AS [ReadingDate],
SUM(Trans2) AS [Trans2],
SUM(Trans4) AS [Trans4],
SUM(Trans6) AS [Trans6]
FROM @Table
WHERE (ReadingDate = @Date AND [Hour] >= 9)...
January 14, 2011 at 7:22 am
As already stated we need more DDL but at a guess....
INSERT PracticeInfo (PracticeID,AdressID)
SELECT s.PracticeID,a.AdressID
FROM [Source] s
JOIN AddressInfo a ON a.Asdress=s.Address
WHERE NOT EXISTS (SELECT * FROM PracticeInfo...
December 13, 2010 at 2:49 am
As for your original question. I would leave all 20 steps in one job and make sure the process flow/dependancies (success/failure) are set right.
Having separate jobs means having a communication...
December 7, 2010 at 4:09 am
WayneS (12/6/2010)
You could always increase the amount of saved rows in the job history.
I did this on my SQL2K server which is OK most of the time but IIRC the...
December 7, 2010 at 3:54 am
Jeff Moden (12/1/2010)
David Burrows (12/1/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
Anyone know if there will be a recording available, 2.30AM...
December 2, 2010 at 2:03 am
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
Anyone know if there will be a recording available, 2.30AM is a tad late...
December 1, 2010 at 7:07 am
CirquedeSQLeil (11/23/2010)
I have yet to taste anything on the internet - bits just don't seem to be worth the effort.
You're right :w00t:
Just stick to nibbles and bytes 😀
November 24, 2010 at 2:18 am
Jeff Moden (11/22/2010)
Hmmm... reminds me... why did I work 71 hours last week? :blink:
Because you're a dedicated professional 😀
And you should know better 😛
November 23, 2010 at 2:08 am
Viewing 15 posts - 1,186 through 1,200 (of 3,543 total)