jasona.work (1/16/2015)

---

So, something good is finally going to happen on Monday.

Well, not good for the wallet, but good overall, which is the important thing...

I'm going to get my home lab...

And this gets passed to a SQL procedure somehow?

Stefan Krzywicki (1/16/2015)

---

Eirikur Eiriksson (1/16/2015)

---

Quick alteration of the code, changed to set based double loop, the trick is to a add variations to the inner loop

😎

DECLARE @BATCHSIZE INT = 255;

DECLARE...

Does this help?

http://www.sqlservercentral.com/blogs/lynnpettis/2009/04/04/a-variable-length-random-string/

And how do we know what year the report is being Generated?

... Mark one off, 43 days on the calendar to go. 43 days on the calendar to go, 43 days to go, ...

Using TRY/CATCH blocks not only allows you to capture standard errors that can occur you can also use them to capture user defined errors that under normal processing would not...

Stephanie Giovannini (1/15/2015)

---

I've inherited a SQL Server database in which the procedures all have try-catch. In all but one case, the catch is:

BEGIN CATCH

DECLARE

...

ryanabr (1/15/2015)

---

Here is an table and an example:

CREATE TABLE [dbo].[DeviceDataStage] (

[DeviceDataID] BIGINT NOT NULL,

...

Phil Parkin (1/15/2015)

---

Same execution plan for my solution, though yours does return the zero time component & is therefore...

... Mark one off, 44 days on the calendar to go. 44 days on the calendar to go, 44 days to go, ...

You still haven't provided the information I requested.

ranuganti (1/14/2015)

---

i am using this below SQLCMD script to insert the output into a sql file which quires multiple servers (DiskMonitorServerList.txt).

But the data is inserted only for the last server...

Don't worry about it. Some people just have...

It would be nice to know 1) the actual requirement, 2) which solution is being used, and 3) do you understand how it works?