Same performance problem, this won't use an index. Don't come back crying in 3 years when the query runs in 3 minutes when it should be in MS.

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=226281

Are you talking about "Current Language"??

Site works only in IE. And ya they Rock .

Doesn't work....

Table will be created. The inserts will fail with error if the limit is met.

Can you tell me how to translate that signature?

This is a great way to make sure performance is non existant. This force a scan of the table/index because of calculations on a field. The between version...

Are you using .NET?

Please post the full code, those error make no sense together.

Please do not cross-post. If someone knows the answer they'll help you.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=20&messageid=226173

Where do you get the ParkID value?

Why do you split the date and time?

insert into itemtypecopy(itemtype, parkid, interestcode, recordstatus, replicate_id, lastupdatedate, lastupdatetime)

select ItemType + ParkID, ParkID, 'None', 'A', 1, CONVERT...

Please do not multi-post.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=20&messageid=226227

Insert into dbo.ItemTypes (Description)

select ItemType from dbo.import where SomeCol = 'x'

No.