Viewing 15 posts - 16 through 30 (of 86 total)
@Erikur,
Further on this, the pagination is only going to kick in after these three right-most operators and the sort, all the work repeated for each page, hence the suggestion...
January 12, 2015 at 3:33 am
@Grant,
yeah, I am also in your side, the business logic is to exclude that filter condition in start and end dates or any one has not provided. so I have...
January 12, 2015 at 2:45 am
Hooovv !! its a good tips boss, I would have a look at it and let you know shortly.. thanks a lot
January 11, 2015 at 5:44 am
Friends,
this is bit urgent and I would feel very greatful if I get any immediate replies.
thanks in advance.
Prabhu.st
January 11, 2015 at 3:37 am
Thanks Koen & Phil,
your values suggestions worked..
Thanks,
Prabhu
August 28, 2014 at 3:26 am
Try out a Execute SQL Task with the following code
create table #temp (cust_id int,phone_type varchar(10),phone_number int)
insert into #temp values(10001,'Home',1234),(10001,'Business',5678),(10001,'Mobile',918239)
selectcust_id,
max((case when phone_type='Home' then phone_number else 0 end)) as home_phone,
max((case when...
August 22, 2014 at 4:17 am
in the advanced tab, the datatype is set to Unicode dt_stwr (something which is equivalent to nvarchar) and the width is 4000, actual data flows through the flat file is...
August 21, 2014 at 12:16 pm
It is a Tab delimited columns
August 21, 2014 at 9:34 am
may be this link would helpful for you
August 20, 2014 at 12:23 am
Hi Livingston,
thanks for your reply, but since it was little bit urgent, i fixed it manualy.
anyway, 4th week's saturday of Each april from the year (calendar year) 2006 is the...
August 19, 2014 at 6:32 am
Gail,
to be simple, all I need is to calculate the fiscal week. on a fiscal year.
start day of a week is saturday and ends on Friday.
the query i got is...
August 19, 2014 at 3:45 am
John,
I will do the correction you suggested, thanks.
Jack.
the answer which you gave me is what I expected, thank you so such..
-Prabhu
August 19, 2014 at 1:43 am
yes, that is the solution I too thought, and make sure you give "Operation"="move" in the file system task editor and overwrite destination set to true.
Thanks,
Prabhu
August 5, 2014 at 7:03 am
your question is not clear,
I can understand two questions.
How can I view / why my files are not visible once it is processed from the package. ?
How can I...
August 5, 2014 at 6:53 am
Hi Gail,
What about jobs?
What about SSIS packages?
What about ad-hoc queries from the application?
this DB is purely for Analysis and there is no jobs are applications using this one, thats...
August 1, 2014 at 8:07 am
Viewing 15 posts - 16 through 30 (of 86 total)