That was exactly what I needed!

Thank you for the help!!!

It would be either the All States, or the individual States.

Not both parametes.

Thanks, Never used a trigger before.

Didn't think of that.

Learn something new daily!

I figured it out. The original creator, specified a username so that only that person would be able to exit the startup menu.

Remove the code portion that looked for a...

Gotcha.

Thanks,

jeff.mason (7/27/2010)

---

No. Do your insert as normal without reference to the ID column. The insert will create the row and generate the identity. The very next statement...

bteraberry (7/27/2010)

---

brian.cook (7/27/2010)

---

So if I add a subquery to the Select statement that has this;

SELECT TOP 1 [ProjectID]

FROM [BE].[dbo].[2010Projects]

ORDER BY [ProjectID] DESC

That should give me the...

ColdCoffee (7/27/2010)

---

Yes ,Brian, right.. but there are better solutions to get teh latest ProjectID.. if you would provide us some sample data, your table structure, then we would happily solve...

So if I add a subquery to the Select statement that has this;

SELECT TOP 1 [ProjectID]

FROM [BE].[dbo].[2010Projects]

ORDER BY [ProjectID] DESC

That should give me the latest ProjectID...

Matt Miller (#4) (7/22/2010)

---

brian.cook (7/22/2010)

---

Matt Miller (#4) (7/22/2010)

---

Jeff Moden (7/22/2010)

---

Joe Celko (7/22/2010)

---

Actually, using the proprietary MONEY is a huge problem. It...

Matt Miller (#4) (7/22/2010)

---

Jeff Moden (7/22/2010)

---

Joe Celko (7/22/2010)

---

Actually, using the proprietary MONEY is a huge problem. It does not divide or...

Thanks Dan. I will look it over.

Brian

With that said, what would you use?

I inherrited the database from someone else. I am cleaning up what I can, and enhancing where it needs to be.

So, what is...

Thanks, I knew it would be something simple!

I appreciate the help. That was the last item I was trying to figure out.

Have a great day!

Correct. Would I use the same function as in Excel? Or something similar?