No need to start a new thread. You already have several people helping. You might be able to do this directly from sql but it would take way more time....

So are the multiple rows per file versions or are they additional segments? Given that it is already in the image datatype I think they are likely versions because the...

And aostanley, excellent job posting your question with ddl, inserts and desired output. Doing that makes it so much easier for people to help. 😀

If you care which one is "first" you will need to sort by more than just type. Ordering by type alone will not always get the same row for each...

Glad that worked for you.

You want to use varbinary instead of image. The image datatype has been deprecated and will no longer be supported at some point in the future....

I think you can just change your datatype in the database and leave your code as is. You are already referencing a binary type. I don't have any experience using...

Here are just a few articles and blog posts referencing reasons to use something other than guids.

http://www.sqlservercentral.com/articles/Miscellaneous/alookatguids/2497/%5B/url%5D

http://www.sqlservercentral.com/blogs/steve_jones/archive/2010/9/8/common-sql-server-mistakes-_1320_-guid-as-a-clustered-pk.aspx

http://www.sqlservercentral.com/articles/Editorial/71378/%5B/url%5D

http://www.sqlservercentral.com/articles/Guids/75506/%5B/url%5D

These are just a few in no particular order (my apologies to anybody if...

From your description I think you must be in sql 2005? You say you have a column of type image so we are all assuming at least 2005. From the...

isuckatsql (12/1/2011)

---

I assume the goal is to keep each table as small as possible?

Based on the above assumption, i have some fields in a candidate profile table, job title(dates...

Glad you figured it out. Can you post your solution so others that stumble in here have an...

eankorins (11/30/2011)

---

Hi, I've tried to search under this kind of topic for quite a while now, and was unable to find anything that fits what I want.

So here is what...

It is a pretty drastic departure from standard thinking. 😉 Basically all you would need to change is the query for your report.

Here is an example to show you how...

michael.french 172 (11/30/2011)

---

Sean Lange (11/29/2011)

---

You can really yourself in trouble with that kind of data structure. You require in the ComputerRoom table a valid Building, Floor and Room. You do...

I tend to be very sensitive about adding columns to the output. As a web developer I tend to bind datagrids to stored proc results and let the grid build...

You will need to split your inbound parameter. Take a look at the link in my signature about splitting strings. It should accomplish exactly what you are looking for.