Dang, you're right! Damn cut 'n paste!

Glad I could help.

Ok, let's start from the table definition script: can you post it please?

You may want to read the article linked in my signature, you would find it useful.

Then change it to OFF. The identity column is there to be computed at the time you insert into the table. If you set IDENTITY_INSERT ON you allow inserts on...

Your syntax is a bit wrong. Try this instead.

Update [databasename1].[dbo].[tablename]

SET [columnname] = B.[columnname]

FROM [databasename1].[dbo].[tablename].[columnname] AS A

INNER JOIN [databasename2].[dbo].[tablename].[columnname] AS B

ON A.PrimaryKey = B.PrimaryKey

Is IDENTITY_INSERT set to ON for that table while inserting?

Can you please provide the table script?

I'm not certified, but I'm plannig to get some cert. It doesn't prove anything, but it's a minimum requirement for some jobs.

Last week I was officially nominated DBA in my...

You can convert it to joins this way:

SELECT B.Id, MinDrawTime = C.DrawTime, MaxDrawTime = D.DrawTime

FROM (

SELECT B.ID, MinRid = MIN(B.Rid), MaxRid = MAX(B.Rid)

FROM @TEMP AS B

GROUP BY B.Id

) AS B

LEFT...

RBarryYoung (2/23/2010)

---

Here's the line (*):

Itzik Ben-Gan, "Calculating Concurrent Sessions, Part 3" (SQL Server Magazine, March 2010)

---

... In a benchmark test that I ran, it proved to be an order of...

Go with OLEDB, forget about JDBC.

I'm using Hit Software OLEDB driver, quite expensive but works well.

Don't mess the countdown please, counting posts in a thread...

Just the time part? OK, take the fractional part only:

DECLARE @test-2 TABLE (

dtColumn datetime

)

INSERT INTO @test-2 VALUES (GETDATE() + RAND())

INSERT INTO @test-2...

Convert the date column to FLOAT, then back to DATETIME:

DECLARE @test-2 TABLE (

dtColumn datetime

)

INSERT INTO @test-2 VALUES (GETDATE() + RAND())

INSERT INTO @test-2 VALUES (GETDATE() + RAND())

INSERT INTO @test-2 VALUES (GETDATE()...

RBarryYoung (2/22/2010)

---

Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come no one...

In my humble opinion, this doesn't belong to SQL.

You'd better do it in some other kind of language / technology.

Not that I'm saying it can't be done, it's just that...

max(seq) over (partition by street)

returns the maximum sequence number in each street group.

In case of ties between different streets, you order by street.

Inside each street group, you want the...