Viewing 15 posts - 46 through 60 (of 60 total)
SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()) +1, 0) AS QStart,July 19, 2017 at 7:27 am
July 19, 2017 at 6:56 am
=IIF(Fields!ColumnA.Value > Fields!ColumnB.Value AND Fields!ColumnA.Value > Fields!ColumnC.Value, "ColumnA", IIF(Fields!ColumnB.Value...July 17, 2017 at 8:34 am
I guess what I need to do is go through the text and and REPLACE clauses in my procedure to remove the tags and finish it off with trims. RIght...
July 3, 2017 at 5:23 am
June 15, 2017 at 6:40 am
June 15, 2017 at 6:03 am
Thanks guys! I actually added the calculated field in my SQL query. mad it a lot easier to do it that way.
Thanks again!
June 8, 2017 at 7:18 am
Thanks everyone for your help and input. Unfortunately I couldn't get the results exactly as I needed. The query was for a SSRS report, so I left the query alone...
June 7, 2017 at 12:04 pm
June 5, 2017 at 11:24 am
June 5, 2017 at 5:34 am
SELECT DISTINCT COUNTY.CountyName,June 5, 2017 at 4:24 am
Rob,
I apologize but i read your message wrong. Yes, in fact they will be able to enter dates after selecting on of the values if they wish to...
May 30, 2017 at 12:46 pm
Rob,
While user input might be nice for the dates, I would rather have them just select one of the values, and the date parameters would automatically be calculated...
May 30, 2017 at 12:05 pm
Viewing 15 posts - 46 through 60 (of 60 total)