Many thanks for the tips and suggestions Jack!

I will go explore around the sites you referenced. Thanks for pointing me in their direction.

Larry

Beulher? Anyone?

Thank you STurner.

I took your suggestions and did exactly what you suggested and I finally got it to work!

The following represents the "fixed" version of the stored procedure which now...

I think Ian's answer will be right-on. I only learned about the "regular expression" engine at a PASS SQL Server Saturday a couple of weekends ago.

The regular expression processing...

Elham,

I think part of the problem might be that you stated that the file is stored as varbinary( nn ) data-type, yet you are pulling the file back into a...

Gosh BSavoie, I tried it out and it all works okay for me.

Here is my test case:

create table #myTemp (

row_id INT IDENTITY( 1,1) NOT NULL,

myTime DATETIME2 NOT NULL

)

INSERT...

Hey Geoff! Many thanks for the interesting article. I always learn a lot by reading these.

I'd also echo the comments by Raj in that I'd like to know...

I think that Gary McGibbon might be onto something.

I ran the stored procedure against my production database, and it literally returned every user table in the database with sequential modify_date...

Thanks Lowell...I was kind of afraid that was the case. It seems kind of like it would be something that a lot of folks would want to know. ...

Congrats Steve and all who contribute here! I stumbled my way to this site about 5 years ago and have been a frequent visitor ever since.

I wish...

Thanks Richard.

I'm looking at the BOL entry for MERGE (T-SQL) and it seems to indicate that it's used to merge two tables. Would it be able to...

Many thanks Craig!

Your example was pretty damn close...with just a couple of minor tweaks I got it to work!

Here's the slightly corrected edition with the right table names:

UPDATE tu1

SET

...

David,

I really appreciate the article. I've always wanted to learn about SQLCLR and your concise (yet useful) example was just the thing to motivate me into trying it. ...

Thank you Adolpho - good article that showed me a new trick, the ISNULL( ) with multiple parameters! I had not seen that before, but could prove quite handy...

Paul - Thanks for your feedback. I reviewed the article which mostly discusses the MAXDOP settings. While it certainly provides something interesting to consider regarding parallelism, I doubt...