Viewing 15 posts - 1,456 through 1,470 (of 8,760 total)
You may find this function useful, instructions and examples in the comments
😎
May 3, 2018 at 6:52 am
Can you post the DDL (create table) script for the table DIM_BILL_INV_ITEM including triggers and indices please?
😎
May 3, 2018 at 1:25 am
May 1, 2018 at 7:56 am
May 1, 2018 at 7:52 am
Can you please post the DDL (create table) script, sample data as an insert statement and the expected results?
😎
My advice is to not use a scalar function...
May 1, 2018 at 7:16 am
May 1, 2018 at 7:11 am
May 1, 2018 at 3:00 am
Further on Tom's fine reply, it looks like you have a greater problem on your hands as it appears that there is a "black box" logic embedded in the front...
May 1, 2018 at 2:51 am
Thanks for this article John, interesting approach.
😎
One thought though, you might want to convert the scalar UDF's to inline functions, big difference in performance when handling...
May 1, 2018 at 1:30 am
April 30, 2018 at 9:59 am
Hi
I have a transaction running that has filled my log drive completely. It's a...
April 30, 2018 at 4:27 am
April 30, 2018 at 1:27 am
April 29, 2018 at 10:23 am
Viewing 15 posts - 1,456 through 1,470 (of 8,760 total)