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: *

  • Users: sqlnew
  • Order by date
  1. sqlnew

    Group by and getting unequal data

    Can any of you please help me with the following query: ID Amount 100 2 100 3 100 4 101 2 101 2 101 2 101 2 102 1 102 1 103 4 103 6 For a Group of particular ID, if the amount is 2, then I want to...
  2. sqlnew

    SQL Query: Assigning values

    Solution in SQL 2005 is fine as I can convert it into PL/SQL. It is the logic that I am having trouble.
  3. sqlnew

    SQL Query: Assigning values

    It is PL/SQL and I am using TOAD to run the queries. Thanks.
  4. sqlnew

    SQL Query: Assigning values

    Dear Forum Members, I am working on a SQL query for couple of days for which I am not able to arrive at a solution: Below is the table structure: Customer# Account # State CreditLimit abc 1 NY 10,000 abc 2 CA 10,000 abc...
  5. sqlnew

    Logon Info for Reports

    I have two crystal reports . Both of them are version 8. Report A asks for log on info as soon as I open it. Report B asks for log on info only when I need to make any changes to the report. (I am connecting to sql server 2008 with specific user name and password). I guess both the reports are...
  6. sqlnew

    Join two tables

    Hi, Please let me know if the below case is possible: I have table t1 and t2 with the following structure. T1 EmpID Bonus Amount 1 10 100 1 20 100 2 5 30 2 5 70 T2 (Bonus in T2 is the Total bonus for each employee) EmpID Bonus C1 C2 1 30 2 3 2 10 4 5...

Part and Inventory Search

Back
Top