sead.j (7/1/2008)

---

It's not homework, but it is...

can you post and example of [Incident date] ?

You may have to do a little bit of VBA in the excel spreadsheet for this to happen automatically

A better solution would be to use Row_Number() to give you some values to page from.

are you able to post your table DML and some sample data for a solution?

Is this query passed as dynamic sql?

If you post your table def, and some sample data i am sure there is a solution...

This is the way that I...

You could save it as a binary data type field in the table.

But you would be better off saving the file path for the document and simply store this in...

The little picture of the padlock , by the stored proc name on the tab, means that the procedure is read-only

You could grab some out of the AdventureWorks database that ships with SQL

Should be fairly straight foward.

Could you post a bit of sample data for your tables ?

Loner (6/26/2008)

---

'Training' - my old IT director said SQL is so easy, anyone can do it why bother to send anyone to training?

What does management know ? This is...

Use;

CHARINDEX ( expression1 ,expression2 [ , start_location ] )

Check BOL for more deails.

Also have a look at this great article on here, on how to use this to step...

great book.

also

Inside Microsoft SQL Server 2005: T-SQL Programming

http://www.amazon.com/Inside-Microsoft-Server-2005-Pro-Developer/dp/0735621977/ref=bxgy_cc_b_img_a

You can quite often...

What sort of help do you need with it?