Lots of good points. I understand how difficult it can be sometimes to get away for vacation. I used to get that a lot and found it very...

I apologize -- I should not have even commented on the thread. I...

KoldCoffee (5/30/2013)

---

Still.....if I weren't unpivoting then I wouldn't have a solution. I wonder....how would I do the equivalent of this?

where

[Month 01] is null and

[Month 02] is null and

[Month...

Technically, I haven't yet purchased any SQL books for it but since I got my Kindle it is my favorite way of reading most books -- it is compact; light;...

mail2payan (5/10/2013)

---

Dear InoLand,

Thank you for this valuable suggestion.

The insert part will one-by-one only, not multiple insert as this a very crucial part and that's why only one person will have...

Are you aware that your trigger will not work if someone inserts multiple rows into the Project table in a single transaction. For instance, try it with something like...

Though I know that I have used...

I was confused by the lack of an option, "Irrelevant, since markup languages should have been abandoned at least 30 years ago." 😉

- Les

If you want help, to start with, you really need to explain what it is you are trying to do. You posted a query which doesn't do what you...

Jeff -

Thanks so much for the articles. I'd read about nested sets some time ago but they looked too unwieldy to maintain. The techniques you have used here...

Lowell (5/11/2012)

---

others will certainly do it differently than I do, but I have three different tables for accomplishing Tally-related objectives:

Tally, which starts with 1,

TallyCalendar, which is all date related.

and Numbers,...

pfm200586 (10/12/2011)Second question :

VendorState----------VendorCity-------------VendorName------------------InvoiceQty-----------------InvoiceAvg

AZ--------------------Phoenix---------------Wells Fargo Bank-------------------1------------------------662.00

CA---------------------Fresno---------------Digital Dreamworks------------------1------------------------7125.34

CA---------------------Fresno------------Fresno County Tax Collector------------1------------------------856.92

CA--------------------Fresno--------------------Pollstar-------------------------1-----------------------1750.00

CA--------------------Fresno-------------------Yesmed, Inc---------------------1-----------------------4901.26

The only problem I see from the choises is that the fifth field name is wrong but the choice says...

Eric M Russell (6/30/2011)

---

I never contain phone or address related columns in something like the primary customer table.

#1 An address or phone number isn't an attribute or measure of...

sku370870 (6/13/2011)

---

The code I posted is made up - the real tables all to do with medicene and would not easily make sense.

But, to continue using my (pseudo) code -...

ShawnTherrien (5/28/2011)

---

So every table in the database has an identity ID field as the PK.

If I take a table like Person and everything related to a person is a...