could you run this for me please :

sp_Helptext 'ddllogger'

mmm

Is that the only code that is on the screen when you hit F5 or run?

Because the error seeems to be in a procedure ddllogger and not in the view?

Thanks

Chris

I agree

I normally always replace spaces with tabs.

I currently work with a tab the length of 4 spaces.

But work with people that insist on reformatting my code to 2 or...

Really why do you hate tabs 🙁

thanks for that 🙂

I thought that might be the case, but thought I would check just in case Jeff had some magic in his pocket he he he

mmm ok Jeff you confused me.

Mainly cause I didn't know you could do that to start with. Secondly I'm not sure how that will help?

Thanks

Chris

Thanks for the alternative Jeff 🙂

but I must say sorry I don't know how the hanging ) stayed as it did.

)

)

Lets see...

yeah I mean I could have a proc that runs the dynamic sql and the dataset returned could be inserted into a temp table and the the main proc just...

Sorry there is user table that basically has the user Id with the field id and what they can and can't see, and yes the query will use different tables...

WOW,

Not sure if it's even worth giving my praise to this master piece of an article after all the praise that has been given already...

But I just can't help myself..

Jeff...

The main reason I'm asking this questions, is because yes this can be done all in sql with pretty good performace.

It just seems weird to solve this problem with a...

Ok let me see if I can supply for info here.

The design of the system is not mine and I can't change it! So with regards to design good or...

Sorry about that:

Ok so this is what is used to create the dynamic query or should I say what is returned here is what I need to use to get...

Good point Steve, I was asking just yesterday about the left join vs NOT Exists, and well Gail gave me a very good visible answer and well ... like you...

Thanks Gail,

Now that is what I call taking the time to explain something with proof 🙂

I could see from the plan it was better but just wasn't sure why..

thanks again...