Viewing 15 posts - 1,201 through 1,215 (of 8,731 total)
Here are a couple of options that are equivalent to each other, but different to the previous posted option.
They read the table twice, but might be able to take...
June 15, 2017 at 9:29 am
June 15, 2017 at 9:13 am
June 15, 2017 at 8:15 am
drs.void_date >= DATEADD(day, DATEDIFF(day, 0, CURRENT_TIMESTAMP), -3)
AND drs.void_date < DATEADD(day, DATEDIFF(day,...
June 13, 2017 at 7:41 pm
Can you post dates that would actually work?
Also, can you post the expected results based on the new sample data?
June 13, 2017 at 1:29 pm
WHEN CAST(drs.void_date...
June 13, 2017 at 12:10 pm
June 13, 2017 at 10:41 am
Are you comparing to one column or multiple columns? You use Table1.Fruit and Table2.Food even when those appear to represent the same attribute. Please post a most detailed example using...
June 13, 2017 at 10:03 am
Please find attached actual and estimated execution plans of...
June 13, 2017 at 7:16 am
create table...
June 12, 2017 at 7:58 am
Instead of making sub-reports, you could use groups and page breaks to separate each "statement". But I'm not sure if you'll get the expected output from it.
June 12, 2017 at 7:29 am
June 7, 2017 at 1:45 pm
A way to tag...
June 7, 2017 at 12:30 pm
Hi and welcome to the forums!
Unfortunately, you didn't post enough information for us to help you. Please read the articles linked in my signature to learn how to post...
June 7, 2017 at 7:08 am
I would disagree with TINYINT: I knew that TINYINT was theintended answer,...
June 6, 2017 at 9:41 am
Viewing 15 posts - 1,201 through 1,215 (of 8,731 total)