That's perfect!!

Thanks for your help Karl

Johann

hmmm I think I am getting there

Now I am getting this:-

SELECT Cars.carID, Cars.fk_vehicleClassID, Cars.carRegNo, Cars.fk_MakeID, Cars.fk_ModelID, Cars.carPrice, Cars.carYear,

Cars.carMileage, Cars.fk_EngineSizeID, Cars.carKms, Cars.fk_GearboxID, Cars.fk_FuelID, Cars.fk_BranchID, Cars.carDesc,

Cars.carSPOffer, Cars.carSPOfferText, Make.makeTit, Model.modelTit,...

Infact, that is what I did

I did a Print @sql at the end, and when both are 0, it gives me the correct SQL statement, but when I...

Hi Karl

I did as you said, varchar(11) however it did not return any results.

So the problem I think is a bit deeper!

thanks mkeast, but I used the COALESCE instead.

Thanks for all your help!

Johann

I solved it

What I did was I created the same owner on my local database and it worked perfectly

Thanks for your help mate

Johann

When I tried to back up from the live server to my hard drive, its not allowing me, giving me "Execute Permission Denied on object 'xp_availablemedia', database 'master', owner 'dbo'"

When I tried to back up from the live server to my hard drive, its not allowing me, giving me "Execute Permission Denied on object 'xp_availablemedia', database 'master', owner 'dbo'"

Hi Sergiy

Is it possible to explain to me what you just told me since I am a newbie.

I know how to put the joins into view, but how to do...

Thanks for your help mate!

Cheers

Sergiy

That was the problem. I had an inner join not returning anything, since the database had some corrupt data which I did not know of!

I cleaned up everything and...

Sergiy

I am trying to build the stored proc step by step

So the above code to retreive all the data from the database:-

CREATE PROCEDURE [dbo].[stpEventsSearchResultNew]

@searchstring varchar(100),

@dtFrom datetime,

@dtTo datetime,

@searchtype int

AS

If @searchtype =...

oh ok thanks

I will keep you informed then

Thanks for ur help Sergiy

so if the count gives me 4 for example, there's a problem?

To tell you the truth, I starter re-writing this SP since I think there is too much complication for...

you mean I comment all the inner joins in the stored proc???