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 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: heatherb0123
- Content: Threads
- Order by date
-
SQL Server - Conditional Grouping??? Need Help!
I am creating stored procedure in SQL Server 2008. I'm a little confused on how to group a specific column only when it meets the criteria below. Can anyone help? I have notes in the code below. Thanks. Criteria: 1) @Coverage & @GroupByMain are optional i.e if a null value is passed for these...- heatherb0123
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
SQL Server Upt Stored Proc Duplicating Records
I'm trying to create a stored procedure that updates records when they exist, and creates a new record when they don't. The code I'm using is duplicating the existing records. Can anyone help? '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' USE [cashNotification] GO SET ANSI_NULLS...- heatherb0123
- Thread
- Replies: 9
- Forum: Microsoft SQL Server: Programming
-
create temp local table from ado recordset
I'm trying to create local Access tables for data linked via ODBC from Sybase (I know the SQL code connecting to Sybase is correct. I tested it in a diff module and it returns the exact # of records). I would like to create tables within access, but I can't get the code to work. Any help would...- heatherb0123
- Thread
- Replies: 8
- Forum: Microsoft: Access Modules (VBA Coding)
