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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: oyam
  • Content: Threads
  • Order by date
  1. oyam

    Problem with FAQ183-5278

    I copied this incredible crosstab procedure, but for some reason, I get bunch of errors trying to create. I am sure I am doing something wrong. Thanks. Osher Here are the errors received: Server: Msg 170, Level 15, State 1, Procedure spCrossTabRun, Line 50 Line 50: Incorrect syntax near ','...
  2. oyam

    Stored procedure changes in report

    I have a crystal report based on a stored procedure and everything works well. Now I added a column in the procedure, but I have a problem to make show in the current report. Is there a way without recreating the whole report? Thanks, Osher
  3. oyam

    Distinct count query

    I am using Access to query FoxPro database. I am trying to have multiple distinct counts. The query works with one distinct count but not with multiples. Here is the query, any ideas? Osher SELECT trnsdate, count(distinct(ordernbr)) as ord_count, count(distinct(ticketnbr)) as employee...
  4. oyam

    terminate inactive sessions

    I have 3 generic users setup on NT box. A large number of users connect at the same time using these generic users. Is there a way to terminate inactive sessions (let's say after 15min) without terminating all other sessions connected as the same users? Thanks, Osher
  5. oyam

    Crosstab query doesn't bring all fields

    Hi, I have a crosstab query that runs well in Access, brings some of data when run in ASP, but not all the data. The query: SELECT TBLE, ADJ_CODE, SUM(DECODE(DAY, '01-MAY-01', ext_val)) "01-MAY-01&quot...

Part and Inventory Search

Back
Top