Search results for query: *

Thank you gh53!!! Worked like a charm. BeachSandGuy

Hi, I have a data table that has elements like the following: UniqueRecord | Phone | Type | Status | 101 | 5551111 | Tech | Closed | 102 | 5552222 | CS | Closed | 103 | 5553333 | Support | Pended |...

Hi, Couldn't find the answer, hopefully someone here can. I have a matrix in RS2008 like this: TIN Location 1/1/12 1/2/12 1/3/12 Total 123456 California 3 4 6 13 345667 New York 1 3 4 8 456677 Nebraska...

Thank you, worked like a charm, learned something new! Ian

Hi, I am attempting to have a query count many thousands of records. Results could look like the following from the following: Select Day, Place, Count(RecordNumber) From Table Group by Day, Place Day | Place | Count 1 | AZ | 15 1 | CA | 20 1 | ID | 3 2 | AZ | 20 2 | CA | 10 2 | ID | 10 How...

Thank you VERY much! That worked perfectly. I misunderstood, and assumed I had to remove from the group by clause too. Appreciate yours and markros input.

I am concerned about the number of records returned. Was thinking by condensing down to a weekly date, it would help. But that gives me an idea, I supposed I could group on year and week number and can convert that with a different query in the reporting services. OR if you have a better way...

Thanks gmmastros! I would normally agree with you, however I am having this query auto run weekly and having the data auto dump into a separate SQL dbase for reporting services website. If I take out the constant, I lose my date field when appending to other weekly data. Is there a better...

Hi, I searched and couldn't find an answer in this forum. I have a query using the group by function to aggregate weekly volumes of calls and dumping into a separate databse. It is designed to be automated, so requires for each pull to include the beginning of the week date. However my...

Hi, I am preparing a sql query to put into an rdl report for SQL Server. I have data which I would like to show up in two columns (for printing purposes). Table looks like this: SiteCode | Description BU | Buffalo DU | Duluth MI | Miami PH | Phoenix I'd like to write a query so the results...

Hey, thank you George! If I wanted to concatenate instead, would that be more flexible as far as varying fields? How would that be done? Ian

Separate columns. Thanks. Ian

Hi, I have been searching and have been unable to find a solution to the following. I have multiple tables, here are some examples. t1 Policy Name EffDate 1 Walmart 1/1/09 2 Target 1/1/09 t2 Policy Phone Type 1 8005555551 1 1 8005555552 2 2...

First, I want to thank both Woody and RiverGuy for taking the time to respond. This is such a great resource and incredible learning experience! Last, RiverGuy, your solution worked very well with one minor modification. In the final or statement in the end, I needed to reverse the order so...

Hi, I am having a problem with a Reporting Services SQL statement. 1st. Have table like the following (omitted non-essentials): Record# - Skill# - StartDate - EndDate 1 - 100 - 1/1/1980 - 12/31/2008 2 - 100 - 1/1/2009 - NULL 3 - 200 - 1/1/2009 - NULL Essentially if the record is "active", end...

Wow, that seemed so simple, and reading it, makes perfect sense, just didn't think to evaluate right side first. Tested, worked great. Thank you so much for your help and very quick reply, George!

Hi, I'm a relative beginner with SQL and reporting and can do some basic reports using SQL and the Report Designer in SQL Server 2005 Visual Studio tools. I have a query to pull results that is relatively simple: Select * From dbo.RouteTable Where EffectiveDate >=@StartDate AND EffectiveDate...