This would be easier to pull off in Reporting Services. Is that an option?

I think you're missing a join.

SELECT FirstName

FROM NewRecs n

WHERE NOT EXISTS (SELECT FirstName

FROM ExistingRecs e

WHERE e.FirstName = n.FirstName);

Note the join between NewRecs and ExistingRecs in the...

That would make a great SQL Saturday half-day or full day precon... I just wish someone would put together even part of that. Sure, you can look up the...

If you stripped off the WHERE clause, it would be a valid query in SQL Server. I would convert the parameters to SQL Server, though.

--put in the real field...

I'll see you and raise...

CREATE TABLE OrderList (OrderNo INT, SerialNo INT, OrderStatus TINYINT);

GO

INSERT INTO OrderList

SELECT 1 AS OrderNo, 100 AS SerialNo, 1 AS OrderStatus

UNION ALL

SELECT 1, 200, 3

UNION ALL

SELECT...

Got sample data? If you want a tested answer, please read this article: How to post data/code to get the best help[/url].

Maybe something like this?

SELECT *

FROM OrderList ol

WHERE NOT...

orenk (12/14/2015)

what I like to do is count a column and group by year. Very easy :-),

select count(*) as Anzahl, year(Datum) as Jahr from KdTickets

where Typ = 1 and...

From Solomon Rutzky on Stack Exchange...

Could you post this in a new thread and post your table structure and some sample data? hard to tell without some details.

You're welcome. Post back if you get stuck.

Surfed around for a second and found this:

http://stackoverflow.com/questions/7542517/call-a-stored-procedure-with-parameter-in-c-sharp

then you'd just call the stored procedure that way.

The code I provided...

This is one option.... kinda sloppy, but it works:

ALTER PROCEDURE uspAddEventParticipant

@ParticipantID INT,

@EventID INT

AS

BEGIN

SET NOCOUNT ON;

DECLARE @MaxEventsPerParticipant TINYINT = 2; -- just makes this a lot easier to modify...

IF (SELECT COUNT(*)...

you could create a stored procedure to do the insert and prior to actually doing it, check the existing count of records for that user and cancel/not do the insert...

To add to what Wendell said, there are several things you need to be aware of when using Access as a front end to SQL Server. To take advantage...

I would check Paul Randal's blog for some ideas. Maybe start here: Troubleshooting Transaction Log Growth[/url]