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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Create a query in SQL server like the parameter query in ACCESS
I'm sorry, I'm transitioning from doing most of my SQL queries in ACCESS. I am now solely in SQL server, without another application to fall back on. I have this query (below), and in Access I could use a parameter to turn these lines in my following SQL query and gifteffdat>'2005-03-31...- velveeta
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
change same field in multiple queries
I currently have a unique ID# in a table, with many other queries and tables attached to it. When I change the unique ID I have to change it in about 10 different queries to make sure it updates all the necessary tables. I want to enter some code or use a macro that, once I decide I am going...- velveeta
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
