ZZartin (5/11/2016)

---

There's nothing inherently wrong with shrinking the database, it's not that it's unsafe and it has a very specific purpose that it achieves. The problem is when people...

I'll need to look at this tomorrow when infront of a computer. To make it easier, with the output can you format it better for first part.

No problem, just as an FYI... not sure if its an assignment or actual work related but if its...

You can use a UNION to combine your result set based on your 3 values, this is one way.

I've ignored the shift type for the time being as I don't...

With what you've just provided, then the above I mentioned earlier isn't suited in this case and a bit more work will need to happen.

What have you done so far...

Sorry to hijack this thread, but I've always read and been told that if disk space is needed instead of Shrinking the .mdf to reclaim the unallocated space, it should...

With the little information you've provided based on that, if there is only Shift1 or Shift2 as options to keep it simple you can use an IF.

Firstly, prior to the...

Ernest Libertucci (5/9/2016)

---

I would just add as a caveat that having unrelated jobs sharing a schedule can have unintended consequences when you think you are changing a schedule for one,...

Disabling a job will stop it from running even if a schedule has been setup.

- Job is scheduled to run at 8am Daily

- Disabled the job

- Job will not run...

site below is very basic and simple to understand... have a read it will hopefully guide you further.. any questions feel free to ask

http://www.w3schools.com/sql/default.asp

Its hard to read your code from all those selects, so I can't work out all the sums, converts, cases etc.... but below I think I've joined it for you...

Jeffery Williams (4/26/2016)

---

No nvarchar anywhere for sure. Hardly ever use, like never. And aware cuts length in half. Paste code in morning. Need permission as...

sounds like something with the NVARCHAR datatype somewhere along the way it might be converting it. you've mentioned it was VARCHAR(8000) so I can only assume somewhere hidden.

Thanks for your help... appreciate it.

John Mitchell-245523 (4/26/2016)

---

I prefer the nuclear option - if the login is no longer required, get rid of it. If you have proper change control procedures, you'll have a...