Quick and simple solution, the problem is trivial if broken down into iteration by the different orders of magnitude, that is 1000 => 1 - 9, 100 => 1 -...

mahikero (3/28/2015)

---

Hi

If I try to connect to ServerName\I01, I get the error below.

"A network-related or instance-specific error occured while establishing a connection to SQL Server.

The server was not found...

Quick thought, you may want to re-think the error handling in the stored procedure, consider this code

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

IF OBJECT_ID(N'dbo.TBL_SAMPLE_RESULT') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_RESULT;

CREATE TABLE dbo.TBL_SAMPLE_RESULT

(

...

Jeff Moden (3/27/2015)

---

ScottPletcher (3/27/2015)

---

Eirikur Eiriksson (3/27/2015)

---

Until the locale driven...

Realize

Quick point, there is a hidden speed trap in the XML concatination, consider this code

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_DIAG') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_DIAG;

CREATE TABLE dbo.TBL_SAMPLE_DIAG

(

...

Until the locale driven implicit conversion starts to produce...

SQLRNNR (3/27/2015)

---

Yes you can certainly get a...

Luis Cazares (3/27/2015)

---

In a different order of ideas, I want to share with you my happiness.

Starting on April 21st I'll be working in the US. I'll make a stop at...

ChrisM@Work (3/27/2015)

---

Question of the day: what datatype is the Estimated Number of Rows (or Estimated Subtree Cost) displayed in the property sheet of the SELECT operator in the estimated plan...

Dandy

djj (3/27/2015)

---

jasona.work (3/27/2015)

---

I hate Fridays around this place...

Unless you've got some project going on that can be worked on when 50+% of the staff is off, you spend a good...

jasona.work (3/27/2015)

---

I hate Fridays around this place...

Unless you've got some project going on that can be worked on when 50+% of the staff is off, you spend a good chunk...

My Friday fun version:rolleyes:

IF EXISTS (SELECT 1 FROM (VALUES(CAST(1 AS BIT))) d (n)) SELECT 1 FROM sys.all_columns X,sys.columns Y,sys.computed_columns Z

Ells (3/27/2015)

---

I have a datetime field that is just the date and zero for the time element. I also have a varchar field that is of the format 09:25:30

is there...