Paul White NZ (7/13/2010)

---

It's a knack 😉

That would work (and Chris would provide a recursive...

Sampathsoft, please can you confirm what position 1.1.3 would assume in your sequence?

Many thanks.

Or 1.1.3, even...

--Sample data creation

DECLARE @TABLE AS TABLE(

[ID] INT IDENTITY,

[Name] VARCHAR(50),

[A/C] char(8),

Balance money)

INSERT INTO @TABLE ([Name],[A/C], [Balance])

SELECT 'Cust 1', '10000001', -£45...

DROP TABLE #TABLE

CREATE TABLE #TABLE (data CHAR(7))

INSERT INTO #TABLE

SELECT '1'

UNION ALL SELECT '1.1'

UNION ALL SELECT '1.1.3'

UNION ALL SELECT '1.2'

UNION ALL SELECT '1.2.1'

UNION ALL SELECT '1.2.2'

UNION ALL SELECT '1.2.3'

UNION ALL SELECT...

Dave Ballantyne (7/9/2010)

---

Chris Morris-439714 (7/9/2010)

---

Can't help but giggle reading that 🙂

Now, how often have you had to tell folks that there's no guaranteed order of results from a query unless...

Can't help but giggle reading that 🙂

Now, how often have you had to tell folks that there's no guaranteed order of results from a query unless there's an order by...

I...

deepankarthiks 21157 (7/8/2010)

---

Chris Morris-439714 (7/8/2010)

---

deepankarthiks 21157 (7/8/2010)

---

Hi,

I have two variable one holds the month value(otherwise month id eg: january - 1 etc) another one holding the complete date.

Now using...

deepankarthiks 21157 (7/8/2010)

---

Hi,

I have two variable one holds the month value(otherwise month id eg: january - 1 etc) another one holding the complete date.

Now using these two i want...

crookj (7/8/2010)

---

I tried in in 1995 - last...

It would be a Franklin.

Hi Brett

You have to use a column list, as in this example:

DROP TABLE #Target

DROP TABLE #Source

CREATE TABLE #Target ([ID] INT IDENTITY(1, 1), Something VARCHAR(10), SomethingElse VARCHAR(10))

CREATE TABLE #Source (Something VARCHAR(10),...

Use a variable for your value of -30.

Employ the function DATEADD()

Take great care with DATETIME data types with regard to the time portion.

Ignore pointless recommendations to use dynamic SQL.

Brett, if the table you are eventually trying to import into has an autoincrementing identity column, then why not use it?