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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BeachSandGuy

    Latest Records with associated Data - Query not working

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

    Interactive Sort failing on Total column

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

    Query limiting the counted records to certain amount

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

    Each GROUP BY expression must contain issue...

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

    Split single column of data into 2 columns

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

    Combine Multiple values into one row

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

    Reporting Services NULL Check issues

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

    SQL for RDL using wildcards with NULL

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

Part and Inventory Search

Back
Top