thanks again gregs. Your help has thought me so much. I realised I needed to add an InvoiceID field to my file_costings table so I can apply a particular costing...

thanks guys. will give this a shot and post back

hi gregs,

this query is brilliant. almost exactly what I need. The first part is 100%. The second part where it does the Pivoting is where I have a problem.

I need...

wow. thanks alot for your help:-) I will give it a try and post back.

here goes guys. sorry for the long delay. Please create a Test database and run the script I am posting. Basically, my main table is the File Table. Each file...

Hi again,

the costings table isn't relalted to file. I will probably need an intercepting table to save a costingid with the fileid. So that tables sole purpose would be to...

hi, this is the costings table. I just created it now:-P

CREATE TABLE [dbo].[Costings](

[CostingID] [bigint] IDENTITY(1,1) NOT NULL,

[Description] [varchar](150) NULL,

[Active] [bit] NULL,

CONSTRAINT [PK_Costings] PRIMARY KEY CLUSTERED

(

[CostingID] ASC

)WITH (PAD_INDEX ...

Hi ALZDBA,

This looks very promising:-D I realised now that I need to return the table from a Function. I tried pasting the code into a Table Valued Function but got...

thanks alot. will try it out now;-)

hi again,

even the original db has no pk:( what other options do I have?

Hi Jeff,

thanks for your help. The reason I don't have a primary key is because I just dump data from another database into ours so we can then import that...

thanks for all your help. I've learnt alot from you;-)

Hi again,

I've added the followinbg to my script

USE [master]

IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE [name] = 'Reality')

BEGIN

-- Create user for SQL Authentication

CREATE LOGIN Reality WITH PASSWORD...

sorry but i'm a bit lost. Is there anyway to get the account info of the user logged into windows in sql server?

Maybe I should tackle this differently. What do...

Hi again,

if I remember correctly there is a check box that asks if you want to add the user to logins as they are not added by default.

Thing is i'm...