This says it all: An explicit value for the identity column in table 'table name' can only be specified when a column list is used and IDENTITY_INSERT is ON.

Looks like...

Personally, I don't think he knows how to read BOL.

CTE's haven't made me forget.  I find them easier to use where I have normally used a derived table in a query.  I don't mind using them, but also look...

I think we could use a little more info.  Could you post the DDL for the source table, some sample data, and the expected output from the sample data.  Be...

Just to confirm, a full backup only backs up enough of the transaction log to ensure a consistant database when restored.  The transaction log backup will truncate all inactive transactions...

One, there are features and capabilities you won't have access to in your QA/DEV environment that you would have access to in your production environment.  I would suggest upgrading your...

What I gave you may or may not work in your situation, but based on the data it seemed to work.  Take it, play with it, read BOL to see...

It might help if you could provide some sample data and what your trying to convert it to.

Oblio,

Based on what you gave me above, how does this look:

declare @datatbl table (

    ida int,

    idb int,

    userid int,

    iddate datetime

    )

insert into @datatbl values(16251,4,13761,'2005-03-26 00:00:00')

insert into @datatbl values(16251,4,16241,'2006-12-07...

I have an idea, post sample data, sample results, and what YOU have done so far and what results YOU have gotten so far.  Then we can help you figure out...

Show us what you have so far.  Perhaps we can see what changes are needed to get it to work.

A little more specific on what you mean optional.  What exactly do you want returned from this stored proc?  Some sample data and results would help.  My suggestion without any...

Try this:

declare @startdate smalldatetime

select @startdate = (Select max(Date_Idx) from dbo.DimDateLM where Date_Idx < '2079-06-06')

set @startdate = dateadd(dd, 1, @startdate)

while @startdate < '2032-01-01'

begin

    insert into dbo.DimDateLM set

        Date_Idx = @startdate

    set...

As this is SQL 2005 (based on where you posted), try putting your hefty query as a CTE and using that in your query.

I had the problem here with QA and SQL Server 2000.  Our network has had issues most of the year for reasons I won't go into that has caused connectivity...