Viewing 15 posts - 106 through 120 (of 279 total)
I have Firstname , firstname 1 , firstname 2 ,firstname3
If firstname is null thne firstname1 , if firstname1 is also null then Firstname2 ...will the case will work ?
Case when...
January 4, 2017 at 8:30 am
I have written code , but it throws error.
SELECT textresponse
,[Last Name] as LastName
,[First Name] as Firstname
[City]
FROM
(
Select
textresponse AS textresponse
,questiONtext
From #T
)AS P
PIVOT(
Max(textresponse) FOR [questiontext] in ([Last Name],[First Name],[City])
)as...
December 14, 2016 at 2:19 pm
So, Merge is good ? I am little confused to use lookup or merge.
November 10, 2016 at 2:23 pm
Thank you. Merge join worked .
November 8, 2016 at 1:42 pm
i am doing look up on destination to see if there is key already exists if not insert new record. SO i cannot send both match and unmatched to destination...
November 8, 2016 at 12:50 pm
I did use lookup on column3 but this way we get only matched data right? i need all data + matched one too to insert into new table.
November 8, 2016 at 12:34 pm
I would do it in tsql ...but wanted to do implment in ssis.
Because table a in one server and table b on other
November 8, 2016 at 11:26 am
Ok. first let me ask. How can we write condition in conditional split where State in (us ,asia)?
November 7, 2016 at 1:00 pm
TABLE A TABLEB
STATUS STATUS
ABCD ABCD If the value are same No insert
BCDG ...
October 24, 2016 at 2:26 pm
Yes..i am deploying from Visual studio 2013. I chnaged property from " encrpyt sensitive data with USer key " to "Dont save sensitive data"....and deployed , i thought that fixed...
October 17, 2016 at 2:21 pm
This is development enviornment and since data is not current need to enforce the data for my testing. Anyways i inserted data without enabling or disabling , just by adding...
October 13, 2016 at 3:47 pm
I think to be more specific, i am deploying the solution from visual studio. the other solution has no issues. only the solution which I am working has this.
Why do...
October 11, 2016 at 3:41 pm
You can write stored procedure and execute it in executesql task and pass value to result set (variables).
or In dataflow task , " query from variable" can be used.
October 11, 2016 at 2:56 pm
Viewing 15 posts - 106 through 120 (of 279 total)