Do you mean you want the report to actually say the text 'null'?

You could modify the reports with ISNULL(<column name>, 'null') statements, or ask whoever is populating those fields to...

jcb (8/28/2014)

---

ZZartin,

That [IncidentDetails].[InsertDate] columns keeps the modification timestamp.

No no other operation and the user is a trained tester looking for this kind of issue, unless he manualy updated that value...

Is there a last modified date on the incidents? Maybe the user changed the status again after setting it to postponed.

WITH TEMP_CTE AS (

SELECT steps, ROW_NUMBER() OVER(ORDER BY steps) AS ROW_NUM FROM #table1

)

SELECT t1.steps, t2.steps FROM TEMP_CTE t1, TEMP_CTE t2

WHERE t1.ROW_NUM < (SELECT MAX(ROW_NUM) FROM TEMP_CTE)

AND (t2.ROW_NUM - 1) =...

bd this is because DTS Packages are not SSIS Packages, the wizard doesn't copy the packages from your 2000 server to your 2008 server it tries to create them as...

SSIS packages are a new thing starting from 2005(they're not just a new name for DTS Packages), what you're seeing in the MSDB node are the SSIS packages created by...

Do you mean you converted the DTS packages to SSIS packages on the 2008 server, or did you just copy them over as legacy dts packages to the 2008 server?

There's some distinction to be made between methodology as in how things get done and what you are trying to get done. As well as distinguising the difference between...

A decent rule of thumb is to take what you would be expecting to make as a salaried employee given your experience, convert it to hourly assuming a 40 hour...

smtzac (8/19/2014)

---

The Log file space use always 99% free, so what's the point keeping same size?

Yes it does, some time Transaction log file (backup from Log shipping) is 100+...

Can you provide more reasons why you need a row number? There might be a solution that doesn't involve row number directly.

Fair enough, if for whatever reason the default is changed.

Replace that with

(DATEDIFF(day, '1/6/2013', getdate()) % 7) < 4

SELECT CASE WHEN DATEPART(weekday, getdate()) < 5

THEN DATEADD(day, 4, DATEADD(week, datediff(week, '1/6/2013', getdate()), '1/6/2013'))

ELSE DATEADD(day, 11, DATEADD(week, datediff(week, '1/5/2014', getdate()), '1/5/2014')) END

This should always get you the next...

patrickmcginnis59 10839 (12/10/2013)

---

ZZartin (12/10/2013)

---

patrickmcginnis59 10839 (12/10/2013)

---

PHYData DBA (12/10/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

Well thats what I was wondering, then and now. What makes RBAR so slow if its not the language? If its...

patrickmcginnis59 10839 (12/10/2013)

---

PHYData DBA (12/10/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

Well thats what I was wondering, then and now. What makes RBAR so slow if its not the language? If its not the language,...