Thanks for taking the time to reply Jeff.

Unfortunately, none of the options you've laid out are viable for me. If I did any of them, the only loser would be...

Probably not the best way to do this, just off the top of my head: -

DECLARE @code NVARCHAR(255);

SET @code = '12333345566689';

WITH CTE(N) AS (SELECT 1 FROM (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))a(N)),

CTE2(N) AS (SELECT 1...

Make sure that you understand it. You've got to support the code, not me 😉

Couple of minor corrections here.

IF EXISTS (SELECT 1 FROM sysobjects WHERE id = OBJECT_ID('xml_to_table') AND OBJECTPROPERTY(id, 'IsProcedure') = 1)

BEGIN;

DROP PROCEDURE [dbo].[xml_to_table];

END;

GO

CREATE PROCEDURE [dbo].[xml_to_table] (@XML XML) AS

BEGIN;

...

This is going to need a lot of testing. Also, I'm not sure that it's the best way to go about this sort of problem. I've written this more as...

Also not exactly a wizard at XML, so I have no idea how this'll scale.

--== SAMPLE DATA ==--

DECLARE @XML XML = '<users>

<userTime>

...

Minnu (11/29/2013)

---

Hi,

Gettting below error

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

is there any method to convert '-' to datetime,

in my scenario,...

What are you trying to achieve? Currently, you're trying to convert the char value "-" into a...

To supplement...

Note: This is the second version of this explanation as the forums ate the first explanation. No...

Ryan Keast (11/6/2013)

---

Hi,

I have the following part in my Select statement -

Select CASE WHEN dbo.[IH_RE-TNCY-PERSON].[ON-TNCY] = '1'

THEN 'yes'

ELSE dbo.[IH_RE-TNCY-PERSON].[ON-TNCY] END AS 'on-tncy',

I get the error -...

Here's some code that replaces your loop and does the same job: -

-- Sample data

IF object_id('tempdb..#sample') IS NOT NULL

BEGIN;

DROP TABLE #sample;

END;

CREATE TABLE #sample (saledate DATETIME, custname...

vignesh.ms (11/6/2013)

---

Thanks for your replies friends...

* My query works what I'm intended to do.

* My expectation is I dont want to hard code the date.

I tried myself, following...

Cadavre (11/6/2013)

---

Stab in the dark because you haven't been very clear in what you want to do: -

-- Sample data

IF object_id('tempdb..#sample') IS NOT NULL

BEGIN;

DROP TABLE #sample;

END;

CREATE...

Stab in the dark because you haven't been very clear in what you want to do: -

-- Sample data

IF object_id('tempdb..#sample') IS NOT NULL

BEGIN;

DROP TABLE #sample;

END;

CREATE TABLE...