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 bkrike 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 smv929

  1. smv929

    SQL proc doesnt run in Crystal--temp tables? Set FMTONLY?

    Thanks guys. By the way, I'm using Crystal 10 and SQL Server 2000 with sp3. vidru/Dave: you are correct. FMTONLY is what was causing the flaky results I saw. The only reason i used it was because someone mentioned that it was a way to solve a problem with temp tables/crystal. It allowed the...
  2. smv929

    SQL proc doesnt run in Crystal--temp tables? Set FMTONLY?

    The procedure at the bottom of this message works only when run in Query Analyzer, but does not work when run in Crystal. It just hangs. Might have something to do with the way I'm using temp tables and possibly the table variable. I found one comment regarding this situation: It said try...
  3. smv929

    Howe to shove a group if there is no data in it...

    I tried creating a view like... Select <real query here> union select ' ' kit_number, '010101' as TIME_COMPLETED,'301' ZONE_NUM, ' ' DATE_COMPLETED, 'W' lnitem_status from dual union select ' ' kit_number, '020101' as TIME_COMPLETED,'301' ZONE_NUM, ' ' DATE_COMPLETED, 'W' lnitem_status from...
  4. smv929

    Howe to shove a group if there is no data in it...

    Ken, I want to show all hours in a report. I have a dummy table (HOURS) that has one field Time_Stamp. It has 12 records like 010101, 020101, 030101 -> 240101. I have a formula (@TimeCov) that returns the hour. I group by this formula. I join the Hours table with the real data table (Pk_Line)...
See more

Part and Inventory Search

Back
Top