20000 records isn't all that much. It should be relatively straight forward to just grab the ROW_ID's of all the relavant entitities from your current production environment then find...

TheSQLGuru (7/16/2015)

---

ZZartin (7/16/2015)

---

Hmm... in that specific case it sounds like you want to run some kind of batch job to update a field which probably would be better done at...

Hmm... in that specific case it sounds like you want to run some kind of batch job to update a field which probably would be better done at the DB...

Ah yes I was looking at the number on the end of the strings 😛 This should do it.

WITH TEMP_CTE_ONE AS(

SELECT TEST_ONE.COL_ONE TEST_ONE_COL_ONE, TEST_ONE.COL_TWO TEST_ONE_COL_TWO, TEST_TWO.COL_ONE TEST_TWO_COL_ONE, TEST_TWO.COL_TWO TEST_TWO_COL_TWO...

If needed change the select to 😀

SELECT CUR_COL_ONE, COL_VALUE, ROW_NUMBER() OVER(PARTITION BY PAR_COL_ONE ORDER BY CUR_COL_ONE) AS SEQ_NUMBER FROM TEMP_CTE_TWO

UNION ALL

SELECT COL_ONE, COL_TWO, 0 FROM #test WHERE COL_TWO = '@@@@@'...

What about something like this assuming no gaps in the identity,

CREATE TABLE #test(COL_ONE int identity, COL_TWO varchar(30))

INSERT INTO #test(COL_TWO)

SELECT 'dfgdfg'

UNION ALL

SELECT 'dfghdgfh'

UNION ALL

SELECT 'dghk'

UNION ALL

SELECT 'rtyurtyurtyu'

UNION ALL

SELECT '@@@@@'

UNION ALL

SELECT 'dsdfgsd'

UNION...

lighter

It is fairly depressing and it's probably...

That should be relatively simple in SSIS, run a query that generates all the copy/move commands and exports them to the batch file, then run the batch file 🙂

It looks like it uses one optional parameter and then calls two other stored procedures for every record returned by the cursor.

SELECT TAB_ID FROM DQ_TAB WHERE ISNULL(@tableID, TAB_ID) = TAB_ID...

Xavon (7/10/2015)

---

It depends. We effectively have two systems, one for managing the business and the other for reporting. For the management system, downtime is more important. For...

Hmm... theoretically you could try making two jobs, the first step of each job does your data load, then the next step calls the other job. That way they'll...

Well is there a reason you need to use robocopy instead of just the standard move command?

Are your backups large enough you actually need to use a non standard windows command to move them?

Well in all fairness any flatfile format that isn't properly generated on the source side is going to break your dataflow. As for why csv are more popular it's...