Thanks for posting the results. Good to see it is finally solved somehow.

Would you mind posting some of your SAN specs?

Will this help?

DECLARE @stmt NVARCHAR(1000)

SET @stmt = 'USE NORTHWIND' + CHAR(10)+'SELECT * FROM Orders'

EXEC sp_executeSQL @stmt

Script section?

That's the way it is. You can't select your favorite fora. Before this forum package, Snitz was used here. And it might be just me, but Snitz was better and...

Expected behaviour. Quoting from BOL (CAST and CONVERT):

When converting character or binary expressions (char, nchar, nvarchar, varchar, binary, or varbinary) to an expression of a different data type, data can...

Interestingly, you need to look at IDENT_CURRENT in BOL to see why SCOPE_IDENTITY() is preferable to @@IDENTITY

Very few things happen "out of nowhere". Any changes to app or db recently? Any entry in log files? Did you run DBCC CHECKALLOC, DBCC CHECKCATALOG or DBCC CHECKTABLE?

Which tool...

Igor,

I haven't looked at it, but I don't question the quality of your code. All I wanted to say is, that 1 post in the right forum is all that...

Wow, certainly more than enough

How should the output look like?

Sorry, but I think this is exactly what I have posted, or? The table GUID_T has a VARCHAR(50) for the GUID. The table GUID_NEW has the UNiQUEIDENTIFIER data type. When...

Now, this looks completely different now. An interesting, yet important part of your problem you didn't conceal here in this thread, don't you think?

Am I understanding you right?

SET NOCOUNT ON

CREATE TABLE GUID_T

(

     guid VARCHAR(50) DEFAULT NEWID() PRIMARY KEY

     , col1 VARCHAR(30)

)

CREATE TABLE GUID_NEW

(

     guid UNIQUEIDENTIFIER DEFAULT NEWID() PRIMARY KEY

     , col1 VARCHAR(30)

)

INSERT INTO...

You should get into the habit, using a considered safe date format like SQL Server's style 112 or 126 to avoid such kind of problems.

See if these help explaining

...cause if you're not specifying the columns of the insert you can have a lot of problems

Even more problems than the use of a cursor will cause?

What about getting rid...

Not sure if I understand you correctly, but wouldn't a FULL OUTER JOIN on Streetcode do the job?

If not, please post your desired output. DDL and sample data to play...