okay so i had a look at some other tables and the field is linked to another table.

so basically if the table contains prj(8345) then i am sure it must...

Hi Mohit

yes i understand what you are saying but this is like really complicated as we pull data from all different tables joining it by a common ID.

Hi Phil

I looked at the two tables and only an ID Field is common between these two.

there seems to be no description field at all.

the problem I have with this is the speed of the query...

any help with increasing the speed??

thanks again to everyone that assisted 🙂

hi everyone

I have found a solution to the problem I had and I thought I should share it here with everyone...

DECLARE @tb_FElectricity AS TABLE (

row int identity(1,1),

cluster_desc varchar(225),

...

I am attaching a new screenshot of the new database that I am currently working on...

I have an ID column which is the primary key ...

and you are right...

I have attached a screenshot of my data.

please have a look 🙂

Hi phil

I have a ID column which is the primary key of my table.

the ID Column can be used to capture a record for the same ID as many times...

Hi thanks for the reply

if my start date and end date is null , then i would like for it to pull the earliest date in the db and the...

i am using SSRS to do this.