Viewing 15 posts - 1,036 through 1,050 (of 3,061 total)
I'm in agreement with Ron in the sense that Business Requirements documentation is needed but I think poster is right when trying to get a proper picture of ETL mappings...
June 4, 2011 at 5:57 am
I'm in agreement with Lutz.
Morevover - just out of curiosity, what are you planning to do with duplicate rows after the update process is done?
delete them?
keep them there forever?...
June 4, 2011 at 5:48 am
programmersunlimited (6/3/2011)
June 3, 2011 at 3:26 pm
lgoolsby 86333 (6/3/2011)
IDXRaw and INVOICES. Both tables have fields INVNUM and MEASURE. IDXRaw will have multiple records with the same INVNUM and MEASURE values. ...
June 3, 2011 at 3:18 pm
laurence 53118 (6/2/2011)
Thanks for your reply.
I know I have a long way to go but learning new stuff is rather fun and better than watching TV of an evening!
What...
June 3, 2011 at 6:19 am
Check t-sql related questions in this forum and attempt to solve the posted issues then, compare your solution whit the one proposed by senior members.
Threads usually include a good deal...
June 2, 2011 at 5:58 am
Welcome to the wonderful world of RDBMS Harry.
First thing first, even when there is just one underlying relational theory implementations are different therefore you cannot expect to be fluent in...
June 2, 2011 at 5:52 am
If - as it appears to be the case - you are not planning to add/update data into operational tables but fully populate them each time then proposed process may...
June 1, 2011 at 4:23 pm
cw.izatt (6/1/2011)
also as a side note any suggestions on good SQL books for somebody in my situation?
Check BOL - Books On Line, it comes with SQL Server for free. If...
June 1, 2011 at 4:17 pm
ShawnTherrien (5/30/2011)
PaulB-TheOneAndOnly (5/30/2011)
June 1, 2011 at 9:46 am
sdhan79 (3/3/2011)
Thank you for your input sir!
Just to add a level of complexity - real world is a complex environment and systems should reflect such a complexity; think about how...
June 1, 2011 at 9:17 am
agustingarzon (5/31/2011)
I can't run the query against the base tables, provided the column names differ from table to table.
Yes you can, just write it. 🙂
June 1, 2011 at 9:03 am
highlord1 (6/1/2011)
Does Anyone know how to to this?
Yes. Use an inline view to check for non-existing rows a.k.a. the ones you want to insert.
June 1, 2011 at 9:01 am
agustingarzon (5/31/2011)
SELECT * FROM [vwUnionAllFields] WHERE [MLNumber] = 123456
vwUnionAllFields is a...
May 31, 2011 at 4:06 pm
Viewing 15 posts - 1,036 through 1,050 (of 3,061 total)