Dunno about your first question but I'm pretty sure that the answer to your second question of can you "view images in SQL Server" is an emphatic "NO".

Heh... flies haven't found it, yet... :hehe:

Thanks, but doesn't quite tell me what you want... not trying to be difficult here, either but "one picture is worth a thousand words"....;)

You listed this as an "input"...

Insert Into...

Yep... I agree with all of that... if it's for GUI code...

For batches, the proc will probably recompile anyway just because the data will have changed enough to need a...

A big key here is that David DIDN'T even use a function (although you could if it's for RBAR GUI code)... it splits a whole table's worth of information in...

Heh... I cheat like hell... load up one staging table with everything... delete the dupes with the "earliest" information... flip the pass-through-view to look at the new table... drink beer...

Ramesh Lende (10/8/2007)

---

I am leaving in remote area of Pennsylvania where it is difficult to find out one DBA. People are coming and they don’t like the place so they...

Backups... if for nothing else, to clear log files that are getting big and growing.

Most people recommend against it for many reasons... most of them are good, some are not... but you could put a view in the Master database and that would draw...

Simple... database is not correctly locked down for changes. No one but DBA's should...

Works fine for what you have... no primary key.

To help, I need to know what you expect the output of your first post to be...

You'd need to split out the images into separate files...

We handle some pretty heavy loads, as well, but on the SQL Server side... that is, when folks stop trying to write Oracle code for SQL Server 😀

Even better!

Heh... thanks David :blush:

But, Serqiy's observations are spot on and I was actually...