;WITH c (current_week,fromdate,todate) AS (

SELECT current_week,CAST(LEFT(current_week,10) as date),CAST(RIGHT(current_week,10) as date)

FROM #mytable

)

SELECT DISTINCT c.current_week,n.current_week AS [next_week]

FROM c

JOIN c n ON DATEADD(day,-8,SYSDATETIME()) BETWEEN n.fromdate and n.todate...

Or OPENROWSET as referenced at the bottom of the link 🙂

1. The Report Server must be able to open a SQL Connection to the SQL Server

(I assume this is OK as you can run the report...

It depends!

Check which method yields the best performance.

p.s.

Which is better

asking SQL Server...

1. You have anerror in your keyword table, both 'already' and 'Deactivated' have id=1

2. Like will not work as 'activated' keyword will find 'activated' and 'Deactivated'

Solution using splitter

SELECT m.[Description]

FROM...

SELECT t.CampusID,t.Campus,t.TermID,t.Term,t.StudentID,t.Qualification,t.Programme,s.Status

FROM [dbo].[MyTable] t

CROSS APPLY (

VALUES

('Repeat1stYear',t.Repeat1stYear)

,('Repeat2ndYear',t.Repeat2ndYear)

,('Repeat3rdYear',t.Repeat3rdYear)

,('ProgTo2ndYear',t.ProgTo2ndYear)

,('ProgTo3rdYear',t.ProgTo3rdYear)

,('ProgToCompleteQual',t.ProgToCompleteQual)

,('NotReturn2ndYr',t.NotReturn2ndYr)

,('NotReturn3rdYr',t.NotReturn3rdYr)

,('NotReturn4thYr',t.NotReturn4thYr)

) s (Status,StatusValue)

WHERE s.StatusValue = 1

;WITH a (ID,ImportGroup) AS (

SELECTc.ID,ROW_NUMBER() OVER (ORDER BY c.ID)

FROM@data c

LEFT JOIN @data n ON n.ID = c.ID + 1

WHERE(c.EventTypeID IN (1,2,4) AND n.EventTypeID in (0, 3))

OR(c.EventTypeID IN (0, 3) and...

After just perusing the query I do not think you will be able to split it in two, it is too large.

Even after replacing tab and crlf with space and...

miles_lesperance (4/11/2014)

---

That worked!! That expression was written by a previous developer, and I was trying to modify it to get rid of the divide by zero error that would occur....

sunil.mvs (4/11/2014)

---

Cake can have x steps and it depends on customer request .. Once work flow starts it starts with 1 and reaches nth...

use this expression

=IIF(Sum(CDec(Fields!Field2.Value))=0,0,Sum(CDec(Fields!Field1.Value))/IIF(Sum(CDec(Fields!Field2.Value))=0,1,Sum(CDec(Fields!Field2.Value))))

and set the format to P2

*Edited to include CDec

You should change your code to not use strings for numeric input

GilaMonster (3/24/2014)

---

It's probably nothing more than a case of "Why's the <app which has been working for years> not working? What do you mean 'who's the administrator'? We've never needed...

If you are using ID for the join you will get a Cartesian result.

How do you know which row in table b belongs to each row in table a?

;WITH cte (CustId,OrderId,OrderDate,RowNumber) AS (

SELECT CustId,OrderId,OrderDate

,ROW_NUMBER() OVER (PARTITION BY CustId,YEAR(OrderDate),MONTH(OrderDate) ORDER BY YEAR(OrderDate),MONTH(OrderDate))

FROM

)

SELECT CustId,OrderId,OrderDate,SIGN(RowNumber)-SIGN(RowNumber-1) AS [CountUnique]

FROM cte

As already stated fix the problem at source.

Probable cause of 'joining' lines is missing CR char ie LF instead of CRLF

If this is the case delimit on LF and remove...