Viewing 15 posts - 886 through 900 (of 3,543 total)
Depending on the data and insert statements you could parse the insert statements into another table and then insert from there
December 4, 2013 at 6:21 am
Did you set the length in both the input and output properties for the column?
December 4, 2013 at 6:10 am
CASE WHEN CASE WHEN date1 > date2 THEN date1 ELSE date2 END > CASE WHEN date3 > date2 THEN date3 ELSE date2 END THEN CASE WHEN date1 > date2 THEN...
December 3, 2013 at 10:47 am
For your data containing 2 months
;WITH
m (Month1, Month2)
AS (
SELECT MIN(Month), MAX(Month)
FROM #tmp_h
UNION ALL
SELECT MAX(Month),MIN(Month)
FROM #tmp_h
),
n (name, subject)
AS (
SELECT name,...
December 3, 2013 at 7:13 am
Jeff Moden (12/1/2013)
dwain.c (12/1/2013)
cow is referred to as wua[/b] - don't ask me why)[/i][/b]
FINALLY!!! AFTER NEARLY 40 YEARS, AN EXPLANATION!!!! When I was in the service, I had a...
December 2, 2013 at 3:18 am
REPLACE(STUFF(Name,1,CHARINDEX('[',Name+'['),''),']','')
November 29, 2013 at 10:29 am
CAST(CAST(someVariable as int) as varchar(30)) + '%'
November 29, 2013 at 6:57 am
Check the width of the body, if this exceeds the paper size it will cause the effect you state.
November 27, 2013 at 7:00 am
Is it exactly 2 days?
Is it +/- 2 days?
How many rows?
One way would be to calculate the day number +/- 2 for the current date and compare that to the...
November 26, 2013 at 9:46 am
Lowell (11/26/2013)
ok, a kewl sneaky way taking advantage of parsename
Declare @TableName varchar(128) ='ABCD_kkk_DDD'
SELECT PARSENAME(REPLACE(@TableName,'_','.'),2)
As long as the string does not already contain full stops 😉
November 26, 2013 at 7:54 am
Why another>
Is there a special requirement?
You could use a splitter, eg DelimitedSplit8K (search this site).
Although this seems overkill for this.
November 26, 2013 at 7:19 am
One way
SUBSTRING(@string,CHARINDEX('_',@string)+1,CHARINDEX('_',SUBSTRING(@String,CHARINDEX('_',@string)+1,255))-1)
November 26, 2013 at 7:00 am
Steven.Howes (11/22/2013)
I should have tested it first...=IIF(Globals!RenderFormat.Name="EXCEL","White", IIf(RowNumber(Nothing) Mod 2 = 0, "Gainsboro", "White"))
I had to reverse the TRUE/False part and the render report format type, but this should work.
Nice...
November 22, 2013 at 8:32 am
Gavin Lock (11/22/2013)
You might be bumping into the Halloween Problem.I was able to repro your problem like this:
Changing the cursor to STATIC will stop your query looping.
November 22, 2013 at 7:28 am
Viewing 15 posts - 886 through 900 (of 3,543 total)