Viewing 15 posts - 8,116 through 8,130 (of 13,876 total)
Pulivarthi Sasidhar (9/16/2015)
I have an SSIS package, which loading 5 data files of same format into Single Destination Table by taking 3-4 Hours...
Now my Manager asked me to change...
September 16, 2015 at 3:11 am
toni 667 (9/16/2015)
I have following problem and I hope someone could help:
I have a table with a datetime and an Item column.
I want to retrieve only the rows where...
September 16, 2015 at 12:50 am
Jason A. Long (9/15/2015)
The easiest way is to simply reverse the order of your ROW_NUMBER... Just sort in DESC order instead of ASC...
I can't see how. Gives this
September 15, 2015 at 11:38 am
Here's one way:
with rows
as ( select * ,
...
September 15, 2015 at 11:02 am
Try this.
select column1 ,
stuff(column1, charindex('@param1', column1),
charindex('@param2', column1)...
September 15, 2015 at 10:34 am
komal145 (9/14/2015)
The Data flow is not working , as the DB2 is a stored procedure with paramters.
I use stored procs with parameters all the time, but not with DB2. Is...
September 14, 2015 at 1:52 pm
Have you considered implementing this as a standard data flow, with your DB2 query as source and the CSV file as destination? It would seem much easier, though maybe I...
September 14, 2015 at 1:11 pm
How is D:\jj\JJ_Data_Extract_20150914103322732.csv related to what you are doing?
September 14, 2015 at 11:12 am
...changed its output as parameter...
Can you please explain what you mean by this?
September 14, 2015 at 11:11 am
mar.ko (9/14/2015)
However, I don't agree that using comma-delimited lists violates any rules of relation theory.
A list is a list....whether it's in table form...
September 14, 2015 at 10:44 am
Kristen-173977 (9/14/2015)
Phil Parkin (9/14/2015)
This is not correct. They can insert into local table variables, which are then returned by the function.
Sorry, I mistook @RETABLE as a parameter to the...
September 14, 2015 at 9:42 am
Kristen-173977 (9/14/2015)
A Stored Procedure could do.
The Function could return the SQL, for the code...
September 14, 2015 at 8:34 am
This seems somewhat long-winded and will not scale well (because it's not an iTVF).
Can you give a bit of background about what you are trying to achieve & what the...
September 14, 2015 at 8:00 am
Kristen-173977 (9/14/2015)
Phil Parkin (9/14/2015)
I would recommend that you create a calendar table[/url] and create a left join from your calendar table to the table which contains data.
Any mileage in looking...
September 14, 2015 at 2:12 am
Viewing 15 posts - 8,116 through 8,130 (of 13,876 total)