Search results for query: *

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

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

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

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

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

Hello All, The db is SQL Server 2005. I have the following data in a temp table. What I'm trying to accomplish is to concatenate the CourseCode for OrderID = 111111 so that the CourseCode will be something like HRD8319,PSY8875 OrderID CourseCode ProductID 111111 HRD8319 42617...

we have a process that drop off file daily to a specific folder on the network. The filename change each day. For example, today file is c:\Test\Employee07132009.xls. Tomorrow file will be c:\Test\Employee07142009.xls. How can I change the file name to c:\Test\Employee.xls. I'm using the...

Hello Forum Experts, I'm using SQL Server 2005. I need to calculate the business hours between two dates for two departments. Here are the scenarios: for customer service: business hours are 8am - 6pm excluding Saturday and Sunday for tech support: business hours are 8am - 10:30pm including...

GroupByCustomer CustName Amt John Doe $100 John Doe -$50 John Doe -$100 ----- Total JohnD -$50 Jane Doe -$50 Jane Doe $100 Jane Doe $50 ---- Total JaneD $100 Foo Bar $250 Foo Bar -$150 Foo Bar -$200...

Hello All, We are on Reporting Service 2005. My Windows user id assigned to a Content Manager role in Reporting Services. However, I cannot view/modify the subscriptions created by other team member. What permission or setting do I need in order to perform this task? Your help/suggestion is...

Hello All, DB platform: SQL Server 2005 I'm trying to create a daily data pull to check for User that have not login to the system for 48 hours. the query below is working fine for Tuesday - Friday run. However, on Monday, I need the logic to exclude Saturday and Sunday hours. For example...

I'm researching a sharepoint project. We have a helpdesk system when the user search for a ticket, if the ticket does not exist in the systems, a message display "No results found". I want to customize the message so it is more user friendly. For example, instead of "No results found", I want...

Hello All, We're using RS 2005. When I print the report from the viewer, the report is printing on multiple pages. It is printing half of the columns on one page and the other half on the second page. However, when I export the report to pdf format from the viewer, it prints correctly on one...

Hello All, I'm trying to accomplish the following: I have shipdate and DaysTakeToDeliver. I'm trying to figure out the ExpectedDeliveryDate without holiday and weekend. Below is the sample data. Shipdate DaysTake ExpectedDeliveryDate 8/29/08 3 9/4/08 (exclude...

Hello Experts, I'm using Reporting Services ver 2005. I'm trying to accomplish the following: I have two group in my report group A and group B Total Amt group A 100 group A -50 group A -30 group A 150 group B = -80 I need to sum the Total Amt for group B only...

I have a float data type field that stored sales amount. What I'm trying to accomplish is to pull the specific digits from this field. For example Amount_ 5565295.24 I want to pull 952 two digit to the left of the decimal (95) and one digit to the right of the decimal (2). I want to use the...

In Excel, there is a grouping function where you can enter a starting value, an end value and indicate increment by to group the data. For example, starting at = 0, End at = 196, By: 7 so the data is group as following: Row_Label Count 0-6 50(between 0 and 6 days, we have 50...

I'm connecting to SQL 2005 through 2000 Enterprise Manager to create a DTS package to send multiple files as an attachment in one email. The following script worked in SQL 2000. However, I got an error message when connecting to SQL 2005: Error Source: Microsoft Data Transformation...