Viewing 15 posts - 1 through 15 (of 150 total)
Thanks everyone. solution provided above works.
April 23, 2022 at 12:31 am
I was able to get this far
IF OBJECT_ID (N'tempdb..#Sol1', N'U') IS NOT NULL DROP TABLE #Sol1
SELECT *,
QtyAvailableToPurchase*Price [TotalAmount],
SUM(QtyAvailableToPurchase*Price) OVER (ORDER BY Price) [RunningTotal],
ROW_NUMBER() OVER (ORDER BY Price)...
April 22, 2022 at 6:39 pm
Thats correct - apologies - its 16 - updated the question
April 22, 2022 at 6:35 pm
Any thought anyone?
June 7, 2018 at 10:57 am
Thanks Joe and Ed for your honest opinions, I would take it as positively. I went ahead and created the DDL as below. I am looking to calculate the average...
August 29, 2017 at 11:11 am
Also How would I SUM the following expression, I am trying the following:
=SUM(Lookup("|"& Fields!Enrollment_Number.Value & "|Quantity Bathroom Faucets|"
, "|" & Fields!Enrollment_Number.Value & "|" & Fields!Property_Name.Value &...
March 1, 2017 at 11:02 am
Similarly :
WHERE CONVERT(varchar(20), H.TransactionDate, 101) >= @StartDate
AND CONVERT(varchar(20), H.TransactionDate, 101) <= @EndDate
--Better would be:
WHERE CAST(H.TransactionDate AS DATE) >= @StartDate
AND CAST( H.TransactionDate AS DATE) <= @EndDate
Do we...
September 20, 2016 at 10:40 am
I would like to see the records from todays date as well.
September 20, 2016 at 10:33 am
Thanks, so L.FundingDate <= CAST(GETDATE()-30 AS DATE) that's the best way to do it.
September 20, 2016 at 10:09 am
Also when I am using parameters like below in the where clause: mostly used in SSRS reports drop down date parameter.
AND CONVERT(varchar(20), CA.when_funded, 101) >= @StartDate
...
September 20, 2016 at 9:55 am
Thanks Everyone.
So basically because of the precedence rule the following would end up giving me the same result?
L.FundingDate <= CONVERT(VARCHAR(10),GETDATE()-30,101)
L.FundingDate <= GETDATE()-30
Also would the following give out the same...
September 20, 2016 at 9:47 am
I am converting getdate to varchar but not converting L.fundingDate to varchar, would that miss out any dates. converting both to varchar is not giving me the accurate results somehow....
September 19, 2016 at 2:08 pm
That's right, it does not have any time portion, so everything 09/30 should be listed
September 15, 2016 at 1:35 pm
If its after midnight 09/30 then shouldn't the date be 10/01?
September 15, 2016 at 1:31 pm
Viewing 15 posts - 1 through 15 (of 150 total)