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 TouchToneTommy 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: GrommitAPW
  • Content: Threads
  • Order by date
  1. GrommitAPW

    Join Problem

    I have a table (tbl_A) and a view (vw_B) - This syntax works - SELECT tbl_A.* FROM tbl_A, vw_B WHERE tbl_A.ID = vw_B.ID This syntax does not - SELECT tbl_A.* FROM tbl_A INNER JOIN vw_B ON tbl_A.ID = vw_B.ID Any ideas ? Thanks, Adrian
  2. GrommitAPW

    Group By Query

    I am converting some Access queries to be 'pass through' to a SQL Server backend. In Access there is a LAST function when running a GROUP BY query - is there an equivalent in SQL Server ? eg table below has columns Type, Quantity & Date. I would like to group by Type, return the latest Date...
  3. GrommitAPW

    Execute SQL Server Stored Procedure from Pass Through Query

    I am converting an Access system to have a SQL Server Backend. For performance reasons I want to convert queries to stored procedures & run them using pass through queries. In a pass through query I am using the syntax EXEC sp_test (5) which works fine. However I would like to pass a...

Part and Inventory Search

Back
Top