Sounds like a nice easy method, thanks!

Any drawbacks?

Thanks for your replies. To restore it, is the easiest way to open management studio, connect to server, right click and choose 'Restore' and follow the prompts?

Are there any traps...

Great, thanks Dave 🙂 Hopefully it all works....

Thanks Dave, I'll have to tweak it a little - I am retrieving the results and putting it into a DataTable to add some columns, etc, before then inserting into...

Apologies, no it's not. I meant to post in SQL 2005. Can a mod move the thread please? Thanks

Ramesh, you are the greatest!

I appreciate all your help, thank you 😀

Thanks Ramesh. The data being returned is still not correct. I've attatched an image to show the data being returned and an edited image to show what it should be.

Thanks Ramesh, your solution works for the most part. I have taken your code, and am trying to apply the WHERE clause as I need to only show data for...

The following three queries should give some structure and data. Any help would be much appreciated.

TABLE

CREATE TABLE [dbo].[tblAssessments](

[AssessmentID] [int] IDENTITY(1,1) NOT NULL,

[UserID] [int] NULL,

[AssessmentDate] [datetime] NULL,

[FollowUpCall] [numeric](1, 0) NULL,

[HealthScore] [int]...

WayneS (5/7/2009)

---

You know, the people that help out here are all volunteers. Providing the CREATE TABLE scripts for the tables affected, and INSERT statements to put some test data into...

Thanks for your reply. I have a single table:

UserID int

AssessmentDate datetime

FollowUpCall int

HealthScore int

The data is only displaying data for a single UserID.

I would like the data to be displayed as:

...