troubleshooting Question

Query Access (Parametric) to Stored Procedure.

Avatar of Joice64
Joice64Flag for Italy asked on
Microsoft AccessMicrosoft SQL Server
9 Comments1 Solution544 ViewsLast Modified:
Hi EE, I have a this problem,  needs to convert my parametric query (Access 2007) to Stored Procedure in SQL 2005, is there a nice utility or tools for make this conversion Job? I have attached the sample Qry with parameters and the code (SQL pass - trought used in Access) and also the table used for this sample.
SELECT RMovAttivita.IDCollaboratore, Collaboratori.Nominativo, TMovAttivita.DataAttivita, Clienti.Nominativo, RMovAttivita.OraInizio, RMovAttivita.OraFine, Prestazioni.DescrizionePrestazione
FROM (Clienti INNER JOIN TMovAttivita ON Clienti.IDCliente = TMovAttivita.IDCliente) INNER JOIN ((RMovAttivita INNER JOIN Collaboratori ON RMovAttivita.IDCollaboratore = Collaboratori.IDCollaboratore) INNER JOIN Prestazioni ON RMovAttivita.IDPrestazione = Prestazioni.IDPrestazione) ON TMovAttivita.IDAttivita = RMovAttivita.IDAttivita
WHERE (((RMovAttivita.IDCollaboratore)=[Collaboratore]) AND ((TMovAttivita.DataAttivita) Between [Inizio] And [Fine]))
ORDER BY Collaboratori.Nominativo, TMovAttivita.DataAttivita, RMovAttivita.OraInizio;
QryParametrics.png
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros