Besides the obvious update you show in your snippet above, are there other updates occuring in the stored procedure that are dependent on this update completing successfully?

It is really hard...

I had it backwards. SQL Server needed to implicitly convert each of the varchar values in your table to nvarchar prior to comparing it to your constant value N'123456789',...

Could be due to the implicit conversion from nvarchar to varchar you introduce by putting the N at the front of the string (N'1234567').

select datediff(minute, dateadd(s, created, '19700101'), getdate())

Combined some of the code from your code in this article with your delimited split routine to solve a problem at work. Inspiration comes from many places.

Have to give...

Compare the following:

DECLARE @Test1 VARCHAR(10) = '01ADA10';

SELECT @Test1 WHERE @Test1 LIKE '%[0-9]%';

SELECT @Test1 WHERE @Test1 NOT LIKE '%[^0-9]%';

fluffydeadangel (11/27/2012)

---

I found the below script works, though i'm still having issues with IF DB_ID(''?'') > 4

IF ''?'' <> ''master'' AND ''?'' <> ''model'' AND ''?'' <> ''msdb'' AND ''?''...

CELKO (11/27/2012)

---

Or not. It's not portable to versions/engines that don't follow that particular ANSI standard which would also discourage people using an older version of SQL Server from helping....

Lokesh Vij (11/27/2012)

---

Just one doubt: Is this method optimized enough of such problems? or...

deep3.kaur 98681 (11/26/2012)

---

I want group data so that the consecutive days for same Location and Contac tName come on one row as Start date To End date.

If they are...

Lokesh Vij (11/27/2012)

---

Just one doubt: Is this method optimized enough of such problems? or...

Lokesh Vij (11/27/2012)

---

Lynn Pettis (11/27/2012)

---

This is what you are looking for:

Create table #Input

(LocationName varchar(20), ContactName varchar(20), AppointmentDate date)

Insert into #Input

values

('Business1', 'C1', '11/12/2012'),

('Business1', 'C1', '11/13/2012'),

('Business1', 'C1', '11/14/2012'),

('Business1', 'C1', '11/15/2012'),

('Business1', 'C1',...

This is what you are looking for:

Create table #Input

(LocationName varchar(20), ContactName varchar(20), AppointmentDate date)

Insert into #Input

values

('Business1', 'C1', '11/12/2012'),

('Business1', 'C1', '11/13/2012'),

('Business1', 'C1', '11/14/2012'),

('Business1', 'C1', '11/15/2012'),

('Business1', 'C1', '12/15/2012'),

('Business1', 'C1', '12/16/2012'),...

Take it offline and see who complains. For safety sake, be sure to have a good backup of it as well.

Glad it works.

Also, did you see how I setup the data for the query? That is how you should post your table DDL and...