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!

Recent content by sqlnew

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

Part and Inventory Search

Back
Top