Recent content by Zurich98

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

Markos, Thank you very much for your helps.