Salaries are already uncapped.

Getting rid of the draft would be the...

By the way, you would really only use the above example with the subquery if there were additional fields that you want to include that are associated with that max...

A simple subquery also works:

SELECT t.id,

t.name,

t.[date]

FROM @Test t

WHERE t.[date] = (SELECT MAX(sq.[date]) FROM @Test sq WHERE sq.id = t.id and sq.name = t.name)

Yes we can!

Lynn Pettis (4/15/2010)

---

My concern with the intermediate table, what happens the first time a customer orders more than 8 products? If you only have 8 products, what happens when...

Is there any purpose for this process other than building a comma delimited flat file for another system?

I would suggest SSIS.

WayneS (4/15/2010)

---

bteraberry (4/15/2010)

---

Manual entry is always a problem, but by extending your constraint over such a large number of fields, the chances of entry errors invalidating the constraint are greatly...

IMO opinion then your primary key should be a composite of:

ID of person entering +

patientID +

visitID

You can just run SQL queries to generate reports on where the same patient/visit had...

So there could be a situation where the same person answers the same questions for the same visit in two different ways and you want to enter both sets of...

So you want the same patient to be able to take the same test on the same visit multiple times so long as they provide different answers? That doesn't...

SQL Server Books Online is your friend.

sys.dm_exec_query_stats:

I've done that before with just a very simple vb.net windows service. All it does is watch a folder and then fire a specific package based on the filename....

Not sure if I understand, but if you want to get values in separate columns rather than delimited in one column, why are you using XML PATH?

That's progress, but I'm still not quite sure what you're looking for. So you only want to do an update if exactly one of the names is found within...