mister.magoo (6/27/2011)

---

You can't put a list (2011, 2012) into an int!

If you want to select multiple years, you will need to look at changing your stored proc to accept a...

Point the trace to a dev server.

Then start the report from the web interface (or whereever it's going to be deployed to)... of course using the test server as datasource.

I...

First instinct :

SELECT ColB - CASE WHEN ColA = 'YES' THEN 1 ELSE 0 END AS ColB FROM dbo.TableB B INNER JOIN dbo.TableA A ON B.id = A.id

If you have a sql 2008 ent or 2008 R2 Standard you could always enable compressions.

However you can't restore there compress and then rebackup because you couldn't restore that on...

You meant these?

http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/

http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

Automate red-gate's sql diff maybe?? Is it even possible to script that out?

take out the last / 1024 in the cte. It will now show it in mbs.

Here's a sample output of the more usefull columns when the full script runs as intended by the author :-P.

DaysUntillDBGrowthdatabase_nameDriveLetterFreeGBs_DriveFreeGBs_Drive_InMonths_WithExpected_DB_Growth

152PROD-FORDIAD19.661.050

150masterC3.18324.232

10modelC3.18NULL

-563msdbC3.18-4.266

mister.magoo (6/27/2011)

---

Ninja's_RGR'us (6/27/2011)

---

mister.magoo (6/27/2011)And the same thing re-written using a CTE - just to show an alternate way to format the code:

;WITH ToDelete AS

(

...

mister.magoo (6/27/2011)And the same thing re-written using a CTE - just to show an alternate way to format the code:

;WITH ToDelete AS

(

SELECT...

Under the covers ssrs sends the query with sp_executesql. It can cause issues with datetimes, any parameters with commas in it and even apostrophes.

fire up profiler to see the...

So what the heck does that tool in the image...

This trick might come in handy :

SELECT SUM(CASE WHEN DateCreated <> DateResolved THEN 1 ELSE 0 END) AS NotResolvedSameDay, SUM(CASE WHEN DateCreated = DateResolved THEN 1 ELSE 0 END)...

Thinking about the resolved part.

Do you have a resolveddate somewhere (is it in another table). That's what would seem the easiest to do.

I never used ps before. So I'll let you finish the script and post it over so that I can just hit GO!