SELECT CAST(

CASE SIGN(DATEPART(dy,@Enddate)-DATEPART(dy,@Startdate))

WHEN 0 THEN DATEDIFF(year,@Startdate,@Enddate)

WHEN 1 THEN DATEDIFF(year,@Startdate,@Enddate)+(DATEPART(dy,@Enddate)-DATEPART(dy,@Startdate))/1000.0

ELSE (DATEDIFF(year,@Startdate,@Enddate)-1)+(DATEDIFF(day,DATEADD(year,DATEDIFF(year,@Startdate,@Enddate)-1,@Startdate),@Enddate))/1000.0

END as decimal(9,3))

Actually ROW_NUMBER was introduced with 2005, you might want to check out the other windowing functions as well, 2014...

Using row number

SELECT ProductId,ProductConfigId,Amount AS [MinPrice],HasGift

FROM (SELECT p.ID AS [ProductId],c.ID AS [ProductConfigId],a.Amount,c.HasGift,

ROW_NUMBER() OVER (PARTITION BY p.ID ORDER BY a.Amount ASC) AS [RowNum]

FROM dbo.TBL_Product p

JOIN dbo.TBL_ProductConfig c ON c.ProductId = p.ID

JOIN...

CREATE TABLE dbo.Person (PersonID int,FirstName varchar(20),LastName varchar(20))

CREATE TABLE dbo.Relation (RelationID int,BossID int,SlaveID int)

INSERT dbo.Person VALUES (1,'Bob','Patel'),(2,'Lun','Smith'),(3,'Julie','Taylor'),(4,'Chris','Pain'),(5,'Joe','Bloggs')

INSERT dbo.Relation VALUES (1234,1,3),(321,3,3),(231,1,5)

SELECT p.PersonID,p.FirstName,p.LastName,

STUFF((SELECT ',' + Name

FROM (SELECT DISTINCT s.FirstName + ' ' +...

Just for fun 😀

SELECT ISNULL(Category,'Total') AS [Category],SUM(Column1) AS [Total]

FROM MyTable

GROUP BY Category

WITH ROLLUP

HAVING Category IS NULL OR Category IN ('Category1','Category2','Category3','Category4')

ORDER BY GROUPING(Category) ASC,Category ASC

Hint: Use CASE statement for Category and use it in GROUP BY

Glad you solved it 🙂

Ooops my bad, I was testing using Value

Why are you using UniqueName, is the report using a cube?

If you put the expression Nazwa pomiaru.UniqueName in another textbox do you get...

I'm on SQL2008R2 and it work for me

What version are you on?

But we cannot...

Check the XML for hidden characters as this would stop the implicit decimal conversion

Try

Switch(Fields!Nazwa_pomiaru.UniqueName = "regulacji", "IRSRZGD", Fields!Nazwa_pomiaru.UniqueName = "tryb", "IRSRZGD", True, Nothing)

although I think this will work as well

IIf(Fields!Nazwa_pomiaru.UniqueName = "regulacji" OR Fields!Nazwa_pomiaru.UniqueName = "tryb", "IRSRZGD", Nothing)

Sum(IIf(DateDiff(DateInterval.Day,Fields!SubmittedDate.Value,Today)>=31 AND DateDiff(DateInterval.Day,Fields!SubmittedDate.Value,Today)<=60,1,0))

Jeff Moden (1/31/2015)

---

It broke my heart during an interview the other day. Some guy had all the right qualities to be a perfect fit for the team but we...

Brian Hibbert (2/1/2015)

---

Try using the FROM clause in the UPDATE statement instead of a select. The right side of the SET = should be your CASE statement, but you...