Viewing 9 posts - 1 through 9 (of 9 total)
Great. I realized that this is not really about CTE's. It is a smart way of taking advantage of the number sequences. Thanks!
October 30, 2015 at 9:36 am
You are right to assume I have an older version (2005 🙁 ). However, I guess I was too short in my sample as this is not the result...
October 29, 2015 at 5:37 pm
Is TransactionID independent from AccountID? Or do you need to include AccountID to uniquely identify a transaction?
AccountID is needed to uniquely identify a transaction.
How common is the use of the...
March 11, 2015 at 3:21 pm
You could bulk insert into a staging table and insert the missing transactions.
Sorry wasn't clear, I already bulk insert from csv into a staging table, then I do delete on...
March 10, 2015 at 7:55 pm
One more note, my data is not normalized. I discovered the scenario below which causes and endless recursion. I can clean it up but just thought I would...
June 26, 2014 at 9:52 am
This is great!! Thanks.
Just one note, this part of the code below I think always resolves as true and I am not sure what it was supposed to do:
(
A.relatedTo is...
June 26, 2014 at 9:20 am
Your code works for this particuar set of rows. If I add two more rows to my table, duplicates appear:
select 18,19,'m' union all <--- new row
select 18,20,'n' union all...
March 11, 2013 at 5:54 pm
Sorry for not being clear.
None of the above. It is not and/or/union.
In my resultset I need all rows to have unique values in column a. There cannot be...
March 11, 2013 at 4:19 pm
your query returns rows g and h which both have 12 in column b.
Thanks for the speedy reply though!
March 11, 2013 at 3:45 pm
Viewing 9 posts - 1 through 9 (of 9 total)