sku370870 (2/10/2013)

---

DECLARE @LastOne bit = 0
CREATE TABLE #tblTasks
        (
        TaskID int,
        Task varchar(50),
        LastOne bit,    
        )
GO
 
INSERT INTO #tblTasks (TaskID, Task, LastOne)
SELECT(TaskID, Task, @LastOne)
FROM tblOldTasks

When doing an insert like the one above - where I am inserting a hard-coded value of 0 for @LastOne column - is there any way of writing such that ...

For every row inserted - insert 0 (or false) as LastOne except for the last row - when LastOne should be 1.

I realise I can do it immediately after the Insert with an Update, but I wondered if there is some way to do it within the Select statement that is inserted.

SQLAJ (2/10/2013)

---

Use default argument for the column.

"DEFAULT
Specifies the value provided for the column when a value is not explicitly supplied during an insert. DEFAULT definitions can be applied to any columns except those defined as timestamp, or those with the IDENTITY property. If a default value is specified for a user-defined type column, the type should support an implicit conversion from constant_expression to the user-defined type. DEFAULT definitions are removed when the table is dropped. Only a constant value, such as a character string; a scalar function (either a system, user-defined, or CLR function); or NULL can be used as a default. To maintain compatibility with earlier versions of SQL Server, a constraint name can be assigned to a DEFAULT."

As seen here: http://msdn.microsoft.com/en-us/library/ms174979(v=sql.105).aspx

sku370870 (2/10/2013)

---

DECLARE @LastOne bit = 0
CREATE TABLE #tblTasks
        (
        TaskID int,
        Task varchar(50),
        LastOne bit,    
        )
GO
 
INSERT INTO #tblTasks (TaskID, Task, LastOne)
SELECT(TaskID, Task, @LastOne)
FROM tblOldTasks

When doing an insert like the one above - where I am inserting a hard-coded value of 0 for @LastOne column - is there any way of writing such that ...

For every row inserted - insert 0 (or false) as LastOne except for the last row - when LastOne should be 1.

I realise I can do it immediately after the Insert with an Update, but I wondered if there is some way to do it within the Select statement that is inserted.

SQLAJ (2/11/2013)

---

I don't believe I said,
"will clearly and certainly make a different entry for ONLY the last row inserted."
I was only trying to provided some information in order to help to further the thought process. Not sure why that would be wrong.