I totally understand and agree with what Jeff said re giving yourself enough time to get things working and working right.

Where I'm coming from is spending a week writing a...

Hi Mark,

I think this could be what you're after:

IF OBJECT_ID('tempdb.dbo.#Attendance') IS NOT NULL

DROP TABLE #Attendance

GO

IF OBJECT_ID('tempdb.dbo.#Roster') IS NOT NULL

DROP TABLE #Roster

GO

CREATE TABLE #Attendance

(

at_studentId INTEGER,

at_status VARCHAR(40)

)

CREATE TABLE #Roster

(

st_studentId INTEGER IDENTITY,

st_name...

Hi All,

As a fairly new T-SQL programmer I can see the benefit of writing efficeintly and sometimes, well let's be realistic, quite often am surprised at 'IT' staff not having...

Hi Johann,

Give the below a try. It will insert one record using the MAX(projectid) from another table.

I think the most important part is the SET IDENTITY_INSERT ON which...