Viewing 15 posts - 1,186 through 1,200 (of 3,544 total)
David Burrows (1/24/2011)
The main problem as I see it is the possiblity of commas between the quotes in a text column.
This will replace commas between quotes with the pipe character
STUFF([column],CHARINDEX(',',[column],PATINDEX('%"%,%"%',[column])),1,'|')...
Far away is close at hand in the images of elsewhere.
Anon.
January 24, 2011 at 7:19 am
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...
Far away is close at hand in the images of elsewhere.
Anon.
January 24, 2011 at 6:55 am
try
exec sp_executesql @ssql,N'@deldate varchar(10) OUTPUT',@deldate OUTPUT
instead of
exec(@ssql)
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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 =...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
January 14, 2011 at 8:43 am
Remove the single quotes around E:\...\claim.xls
Far away is close at hand in the images of elsewhere.
Anon.
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)...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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 😀
Far away is close at hand in the images of elsewhere.
Anon.
November 24, 2010 at 2:18 am
Viewing 15 posts - 1,186 through 1,200 (of 3,544 total)