Viewing 15 posts - 1 through 15 (of 107 total)
Ok, I will work on it.
November 13, 2015 at 4:08 am
Yep, that's already in place.
The only thing which I am concerned about is running multiple packages in parallel. I have 16 processors running on my server and I want to...
November 12, 2015 at 8:00 pm
There are various interfaces which are independent, so they would be executed in parallel. However, we've a changing req. and in future there would be more interfaces coming and we...
November 10, 2015 at 3:22 am
You have to do it at SQL level only, perform data validation check and move that row to another table which will store bad records.
November 9, 2015 at 10:10 pm
Sorry, I don't have the deadlock graph available.
In JOB1 - I have a file to table load via SSIS (fast table load)
In JOB2 - I am fetching some data from...
October 6, 2015 at 11:37 pm
I've created this query, it is giving me desired results, but I am not sure if it is correct.
;WITH CTE AS
,NTILE(2) OVER (PARTITION BY id,rn ORDER BY descr DESC)...
August 26, 2015 at 9:41 pm
Keeping amount as individual sets
AMOUNT | STAGE
10 | 4 } 1st SET
10 | 3...
August 26, 2015 at 9:30 pm
This is because.
One process for amount 10 was started @ 3 and ended @ 4.
But, for another amount 10 process started @3 and has not ended yet. So the latest...
August 26, 2015 at 5:13 am
Eirikur Eiriksson (8/26/2015)Quick thought, the description of the logic does not fit the expected results, can you please amend either or both?😎
Eirikur Eiriksson (8/26/2015)
Actually the data comes in sets.
1 set contains two...
August 26, 2015 at 1:54 am
Here's a simple one -
select AttribName AS Attribute
,CASE WHEN ISNUMERIC(AttribValue)=1
WHEN LEN(ATTRIBVALUE) = 1 AND ISNUMERIC(AttribValue) = 0
August 19, 2015 at 1:36 am
Load all data to your destination server and then use MERGE there.
I hope it would be faster and easier to use.
August 4, 2015 at 3:06 am
Out of 3 DFT 2 DFT have sourceA and Last DFT have difrent source.
August 4, 2015 at 3:03 am
It seems none of the queries are correct. Correct one is:
ALTER DATABASE AdventureWorks2012
MODIFY FILE (NAME=AdventureWorks2012_data, NEWNAME=AWD2012 );
August 2, 2015 at 10:02 pm
I guess using a foreach loop will do.
1>Fetch conn string, table names from master_table.
Your DFT's here.
July 29, 2015 at 4:36 am
greggg (7/23/2015)How would I go about getting additional information from the subquery, like the ServiceDate for the record?
You can use a CTE if required. If you can provide some more...
July 24, 2015 at 1:10 am