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 Zurich98

  1. Zurich98

    Find Specific Date Base on a Control Date

    Thank you all for your helps. I use simian336 code. simple and got what I need.
  2. Zurich98

    Find Specific Date Base on a Control Date

    Hello All, I'm using SQL 2005. How do I find a second Wednesday base on a date? For example, date = 10/25/2010. The date I'm looking for is 11/3/2010. Your help/suggestion is greatly appreciated. Thanks
  3. Zurich98

    Count Query Help

    will this work? SELECT Dealer.Code ,sum(case when QuoteItem.[Type] = 'JOB' then 1 else 0 end) as StandardJob ,sum(case when QuoteItem.[Type] = 'CJOB' then 1 else 0 end) as CustomJob ,sum(case when QuoteItem.[Type] not in ('JOB','CJOB') then 1 else 0 end) as MISC FROM Quote INNER JOIN Dealer...
  4. Zurich98

    Building Begin and End Week Data

    Hello All, I have a table contain CourseStartDate and CourseEndDate. The week will always begin on Monday and end on Sunday. If I have CourseStartDate = 10/25/2010 CourseEndDate = 12/19/2010 How do I create the following data set Week StartDate EndDate 1 10/25/2010 10/31/2010 2...
  5. Zurich98

    Truncate text

    i use the case statement below and it seems to work but not sure if this is the most effective way to go about it. case when CourseName like '%-%' then rtrim(SUBSTRING(CourseName, 0, CHARINDEX('-', CourseName))) else CourseName end
  6. Zurich98

    Truncate text

    Thank you for your quick response. However, the code only work when coursename contain '-'. It does not return a value for Physic One and Chemistry Beg (first two rows in the example). Please advise. Thanks
  7. Zurich98

    Truncate text

    Hello All, I'm using SQL 2005. I have a text column with the following data: CourseName Physic Physic One - SS retake - Oct Physic One - SS retake - Nov Physic One - SS retake - Dec Chemistry Beg Chemistry Beg - SS retake - Oct Chemistry Beg - SS retake - Nov etc... How do I truncate all...
  8. Zurich98

    Finding Specific Position in a String

    hello all, I only want the string after the second "\" in the string below: 'C:\DailyReports\April2010' How can I accomplish this? Your help/suggestion is greatly appreciated. Thanks
  9. Zurich98

    Printing in Front and Back

    oopss...i just realize i posted this questions a few days ago. if someone could provide more detail then the previous response. Thanks
  10. Zurich98

    Printing in Front and Back

    Hello All, We are using RS 2008. I have a report that would like to print on both side of the paper (front and back). Is there a setting somewhere in the report or on the server to accopmlish this. Your help/suggestion is greatly appreciated. Thanks
  11. Zurich98

    Print on Front and Back

    Hello All, I'm using RS 2005 and 2008. What setting or coding do I need to be able to print the report on Front and Back of a page? Your help or suggestion is greatly appreciated. Thanks in Advance
  12. Zurich98

    One - Many Relationship

    I was about to go the long way by using identity(smallint,1,1) as RowNmbr and then pick the min or max by RowNmbr. I didn't realize I can use min and max function on text field. Someone else in another forum suggests the same idea. Thank you for your help.
  13. Zurich98

    One - Many Relationship

    Hello All, My envinronment is SQL 2005. The data in my table is as follow: ID Test 1 Tax Exempt 1 Tax Composition I would like to pull only one Test for this ID. It does not matter which test. I don't have a date field or any other unique key to differentiate...
  14. Zurich98

    Newbie writing SRS reports

    You need to create a data set base on the table you created (choice). add a parameter to the report and connect it to the data set you created. --create data set Data tab, click drop down and select New dataset. Name: Choice Data source: connection to your db Command type: text Query String...
  15. Zurich98

    Concatenation

    Markos, Thank you very much for your helps.
See more

Part and Inventory Search

Back
Top