Viewing 15 posts - 886 through 900 (of 3,544 total)
You could add derived columns for missing columns to each transformation to make then the output the same and then use SSIS UNION to produce a single dataset
Far away is close at hand in the images of elsewhere.
Anon.
December 4, 2013 at 6:35 am
Depending on the data and insert statements you could parse the insert statements into another table and then insert from there
Far away is close at hand in the images of elsewhere.
Anon.
December 4, 2013 at 6:21 am
Did you set the length in both the input and output properties for the column?
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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,...
Far away is close at hand in the images of elsewhere.
Anon.
December 3, 2013 at 7:13 am
nuff said 😛
Far away is close at hand in the images of elsewhere.
Anon.
December 2, 2013 at 7:36 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...
Far away is close at hand in the images of elsewhere.
Anon.
December 2, 2013 at 3:18 am
REPLACE(STUFF(Name,1,CHARINDEX('[',Name+'['),''),']','')
Far away is close at hand in the images of elsewhere.
Anon.
November 29, 2013 at 10:29 am
CAST(CAST(someVariable as int) as varchar(30)) + '%'
Far away is close at hand in the images of elsewhere.
Anon.
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.
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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 😉
Far away is close at hand in the images of elsewhere.
Anon.
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.
Far away is close at hand in the images of elsewhere.
Anon.
November 26, 2013 at 7:19 am
One way
SUBSTRING(@string,CHARINDEX('_',@string)+1,CHARINDEX('_',SUBSTRING(@String,CHARINDEX('_',@string)+1,255))-1)
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
November 22, 2013 at 8:32 am
Viewing 15 posts - 886 through 900 (of 3,544 total)