Viewing 5 posts - 1 through 5 (of 5 total)
I did end up figuring this out by the following:
select b.Name, a.Category, COUNT(a.OrderNumber) as 'Total Orders',
((sum(
CASE
WHEN b.UserID = a.EnteredUserID and c.OrdSourceID <> 'PROTOCOL'
THEN 1
ELSE 0
END) * 100 /...
September 18, 2012 at 12:28 pm
Awesome - thank you! I did an 'open with Excel' and I can view it much better than a text file. I'll see if this will work for my...
August 30, 2012 at 1:28 pm
Sorry I had no clue how that worked. OK, that did create a file. Is there a way to change the default file format? It saves it...
August 30, 2012 at 1:21 pm
Actually I have done that. However when I select that, nothing happens.
August 30, 2012 at 1:12 pm
AWESOME - thank you I think I got it to work!!!!!!!!
June 29, 2012 at 1:47 pm
Viewing 5 posts - 1 through 5 (of 5 total)