Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MegaSQLBI

  1. MegaSQLBI

    DATEADD on Linked Server

    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...
  2. MegaSQLBI

    Advise on SQL Pivot

    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...
  3. MegaSQLBI

    Advise on SQL Pivot

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

    Replace multiple items

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

    Dynamic Like Clause

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

    Dynamic Like Clause

    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
  7. MegaSQLBI

    Inactive step of job

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

    PCI certification and security question

    Yes, that's right.
  9. MegaSQLBI

    PCI certification and security question

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

    Brainwash Design Table

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

Part and Inventory Search

Back
Top