Search results for query: *

try this one... select print_ticket_ind, Class_name,Status,acct_id, section_name, event_date, event_time,printed_datetime from openquery(premclub, 'select * from dba.v_ticket where Class_Name = ''PC_Default'' and Status = ''Sold'' and print_ticket_ind = ''y'' and section_name like ''ST%'' or...

using Pivot function SELECT location, fmtitemno as ItemNo, [1] AS Price1, [1001] as ReceiptNo1, [2] AS Price2, [1002] as ReceiptNo2, [3] AS Price3, [1003] as ReceiptNo3, [4] AS Price4, [1004] as ReceiptNo4 FROM (SELECT location,fmtitemno,docnum, averagecost, rk , rk + 1000 rknew FROM...

could you please post your original table and sample data? Meganathan

Hi Gmmastros This is amazing solution! Hats off to you. Cheers! Meganathan

It's replacing Comma's with %' Or Unit Like '% and adding necessary prefix & suffix to complete the syntax. Meganathan

try this one declare @v_input varchar(50) declare @v_sql varchar(1000) set @v_input = '6,IC,5' Select @v_sql = 'Select * From Units Where Unit Like ''%' + REPLACE(@v_input, ',', '%'' Or Unit Like ''%') + '%'' ' Select @v_sql Exec (@v_sql) Mega

That's right approach. Ex: Step 5 you want to ignore/inactive then on Step 4 make it on success go to Step 6

Yes, that's right.

GRANT EXECUTE ON <stored proc name> TO db_runprocs - Gives access only to that specific procedure

George you are a master :) Nice tip! Thanks Mega