It was my first attempt at a CONSTRAINT. I'm well known for taking baby steps in my technique and code. If I were more experience, then I'd be bothered, but...

Roy Ernest (7/26/2010)

---

I seem to miss something here. You only require the user name to check what permission they have and use that user name for logging purpose?

Please keep in...

Yeah, I was thinking that it'd be an AD group. I keep having the pleasure of having new things thrown at me quite unexpectedly and wanted to have some idea...

I think I've got it. The join was on the primary key in the parent to the foreign key in the child. The correct join needed to be on the...

Steve Jones - Editor (7/19/2010)

---

Sorry, no, modify the data in a table.

If I have Customers:

Create table Customers( Customer varchar(20))

go

insert Customers select 'Acme'

union select 'Brad'

go

Now I want to change the Customer...

So you're saying that the big thing to consider...

Actually now that I think about it, I'm liking the idea of the ASPX page generating an email and then setting up rules in Outlook which move the message to...

It is an Access/SQL Server app.

I did think about using the Front End, however the fact that two users on two different machines might update it disqualified that, until a...

Its geared toward providing the users with the information immediately if its not accessible, regardless of for how long. The department needing it is such that when we're busy they're...

Both actually. To be specific, is it possible to do something where in a trigger fires a sp that grabs records and then essentially exports them to a text file,...

david.c.holley (7/14/2010)

---

I've started playing around with table type functions. I've got one up and running that takes a parameter and returns the expected results.

Where do I need to go in...

That's entirely a possibility.

It does also solve another question that I had that I've seen crop up here and there about selecting the oldest or youngest child record for...

RakeshRSingh (7/13/2010)

---

As per the execution of the SQL Statements that you have provided,

1. First the From clause will be processed

2. Then WHERE clause will be processed

3. Then SELECT clause will...

Eric Mamet (7/6/2010)

---

I must admit that 150 columns sounds bizarre but that's because the end user wants that data as a crosstab table.

I do a kind of pivot dynamically....

I need the query to pull all parent records and each one's most recent child.