Notwithstanding the above comments, I think using a static datetime value would have been better to remove ambiguity.

Also there is no mention in the answer of the datatype precedence in...

Check

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bc47050a-a733-4a27-a55a-64159453d83e/missing-tabs-and-site-settings-link-in-report-manager?forum=sqlreportingservices

and

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b4ea04c4-0135-4c9d-86e2-8c3e510585c2/reporting-service-administrator-account-missing-site-settings-link?forum=sqlreportingservices

Jeff Moden (8/18/2016)

---

You're mistaken. It's not a contest. I'm just interested in possible differences in performance and I'm interested in seeing the actual package because most people don't...

Luis Cazares (8/9/2016)

---

Even if with this amount of rows it might make no difference, avoid using recursive CTEs to count. Here's another version which might seem too wordy, but it...

WITH

cte (MonthEnd)

...

Y.B. (8/9/2016)

---

Hi David,

I think you have a typo in your values...shouldn't that 32 at the end be a 52?...

SELECT DATEADD(week,Weeks,@StartDate) AS [MonthEnd]

FROM (VALUES (0),(4),(8),(12),(16),(20),(24),(28),(32),(36),(40),(44),(48),(52)) w (Weeks)

SELECT T.ID1,

CAST(T.[StartDate] AS DATE) TaskStartDate,

MAX(CASE WHEN DATEDIFF(DAY, getdate(), T.[StartDate]) > 0 THEN ROUND(0 ,3)

...

SUBSTRING([column],PATINDEX('%[^-]%',[column]),255)

Grant Fritchey (6/3/2016)

---

As well as upgrade them independently of Service Packs and Cumulative Updates. I for one used to always forget to make sure I ran those on machines that...

If you replace DateAndTime with Value in the ORDER BY, it will be correct 🙂

Too easy when you give the answer 😛

Mind you it's what I normally do 😀

Use

WHERE to filter the data

ORDER BY to put the data in the required order

TOP to restrict the output to one row

Post what you have so far and someone will help

In the beginning there was SQL Server.

God said 'Let there be light'.

Click!

And there...

You need to wrap the subquery with another select and use FOR XML

like this

DECLARE @rssbody XML;

SET @rssbody = (

SELECT FLDB,PROC_SET_CODE,PROC_SET_NAME FROM (

SELECT 'Fl01' as FLDB, PROC_SET_CODE, PROC_SET_NAME

FROM [Fl01].[dbo].[PRSM]

WHERE PROC_SET_CODE...