aitchkcandoo (1/20/2012)

---

Drew, I read what you said about starting a new thread. With deference to your seniority on this forum, may I disagree? I think it is good to...

CELKO (1/20/2012)

---

I like the MySQL convention of using double zeroes for months and years, That is 'yyyy-mm-00' for a month within a year and 'yyyy-00-00' for the whole year. The...

kevmck (1/20/2012)

---

While I appreciate the advise, the page you linked really didn't tell me a whole lot, except give me the indication that I'd be using a sledgehammer to kill...

Fahey's logic above is what I used in coding my response, since that is how ages are typically calculated and age was specifically mentioned.

Drew

aitchkcandoo (1/20/2012)

---

will you please be explicit? The subquery alone doesn't work:

select fname

,lname

...

I think that part of the problem is your database design. It sounds like your problem should be implemented using the geometry data type which has methods specifically to...

You just use a CROSS APPLY and replace the variable name with the column name.

SELECT *

FROM YourTable

CROSS APPLY (

SELECT c.value('b[1]', 'varchar(10)'), c.value('c[1]',...

I think the actual problem is the PRINT command. PRINT will only show a certain number of characters (I forget the number) and it sounds like you may have...

This should work.

select fname

,lname

,ssn

from ( select fname

...

Your XML is mal-formed. XQuery requires a single root element, which yours doesn't have and the end tag for your <C> element doesn't match. I've corrected the XML.

DECLARE...

Lowell (1/17/2012)

---

i have tehse saved in my snippets; does this do what you want?

--elapsed time/datediff

select [Years] = datediff(year,0,ET-ST)-1,

...

I think this will give you what you are looking for. It depends on the fact that the variables are set in left to right order. You can...

Sean Lange (1/18/2012)

---

I would ask though why do you need more than 1 column that is unique? The point of a unique index is to allow you to identify any...

You have a value for BID in your C table that doesn't have a corresponding value for BID in your B table. The best way to resolve this is...

My point is that it's not only possible, but extremely likely to read your comments as recommending using an rCTE for new development for...