There is another option.

You could the objectID's for the tables and build a dynamic query which would only require you to type one select and then print or execute the...

Hi there,

Do you want to find all the records that say have emp_ID = 100

You could use a UNION

You could use temp/table table variables

Does this help?

Thanks

Chris

HI there,

What version of SQL you using?

If you using 2005 you could use the pivot functionality if you using 2000 you could use case statements

thanks

Chris

HI guys,

I have created a proc that tries to create all triggers for insert/update and delete auditing

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1950

see if this helps

Have you tried this.

select distinct dbo.tbl3215.ittnumber, dbo.tbl3215.itttitle, dbo.tbl3215.daterequired from dbo.tblassignment inner join dbo.tbl3215 on dbo.tbl3215.ittnumber = dbo.tblassignment.ittnumber inner join dbo.tblfltwrkcntr on dbo.tblfltwrkcntr.fltwkcntrid = dbo.tblassignment.assfltwrkid where ((itttitle is not null or...

Hi again 🙂

Would it be possible for you to post the code?

Thanks

Chris

Hi Lim,

I'm pretty sure that when you are using dynamic SQL you are restricted to a varchar variable of 4000 chars.

Try breaking you query up into smaller parts and executing...

Hi Steven,

Not sure if this is teh most process affective way of doing it but it's a good starting block I think:

CREATE TABLE ##VtblTables

      (

     ...

HI There,

Are you reports run at the sametime everyday?

Do you need realtime data?

Thanks

Chris

HI Tom,

Sorry for the delay.

Could you try replacing the highlighted section with the following.

cast(stuff(stuff(Date_Created,5