Viewing 15 posts - 2,236 through 2,250 (of 3,957 total)
Not sure what happened, but the first script under the Sign Reversals section should look like this:
TRUNCATE TABLE #Trans
INSERT INTO #Trans (Amount, [Sign])
SELECT 100, '+' -- [Assigned ID is...
January 7, 2013 at 12:07 am
GilaMonster (1/6/2013)
Stefan Krzywicki (1/6/2013)
GilaMonster (1/6/2013)
Stefan Krzywicki (1/5/2013)
January 6, 2013 at 6:46 pm
davoscollective (1/6/2013)
dwain.c (1/2/2013)
You should use this instead:
CAST(VARCHAR(19), @EndDate,120)Or if additional precision is required (milliseconds) use:
CAST(VARCHAR(23), @EndDate,121)I think that should have been convert, not cast. I'm sure just a typo.
Yup....
January 6, 2013 at 6:42 pm
Apparently Lowell was thinking of me for some reason (not sure why) when he posted so I couldn't help but chime in!
You might want to take a look at the...
January 6, 2013 at 6:33 pm
I tend to agree with Joe on this. Scrub the data in your front end application.
Given that, at this point in time, you've probably already collected lots of garbage...
January 6, 2013 at 5:24 pm
How about something like this instead?
;WITH Notes (Note) AS (
SELECT '8Am to 6PM Mon-Fri| |Tow: 3PM to 8PM Mon-Fri, 4AM -11PM Fri-Sat| Clean: 9AM to 11PM Mon-Fri, 4AM -7AM Fri-Sat|...
January 6, 2013 at 5:20 pm
At the risk of further confusing this thing, I'm going to offer you another alternative.
See the 4th article in my signature string (Pattern Splitting) to find a FUNCTION called PatternSplitCM...
January 4, 2013 at 6:27 pm
tbmabry (1/4/2013)
January 4, 2013 at 6:21 pm
Steve Jones - SSC Editor (1/4/2013)
dwain.c (1/3/2013)
Evil Kraig F (1/3/2013)
Any twitter folks here use a samsung galaxy? If so, what app do you recommend?
About a week and a half...
January 4, 2013 at 5:59 pm
kl25 (1/4/2013)
January 4, 2013 at 5:56 pm
Saurv (1/4/2013)
CROSS APPLY (
VALUES(High, 'High', DATEPART(dw, CAST(DateID AS CHAR(8))))
,(Low, 'Low', DATEPART(dw, CAST(DateID AS CHAR(8))))) a (Val, Type, weekday)
GROUP...
January 4, 2013 at 5:52 pm
ScottPletcher (1/4/2013)
CELKO (1/4/2013)
January 4, 2013 at 5:50 pm
Bhuvnesh (1/4/2013)
dwain.c (1/1/2013)
CROSS APPLY (
VALUES(High, 'High', DATEPART(dw, CAST(DateID AS CHAR(8))))
,(Low, 'Low', DATEPART(dw, CAST(DateID AS CHAR(8))))) a(Val, Type, weekday)
GROUP...
January 4, 2013 at 3:35 am
You should be able to create an all-SQL solution without a CURSOR for this.
I suggest you look into CROSS (or OUTER) APPLY.
January 4, 2013 at 2:34 am
By George I think I've got it.
Stick with the first two queries provided earlier. Use the following (that sets up Dynamic SQL) to complete the divide and conquer solution.
DECLARE...
January 4, 2013 at 2:21 am
Viewing 15 posts - 2,236 through 2,250 (of 3,957 total)