I believe it goes something like this

INSERT INTO table1 DEFAULT VALUES

That is if what you say is true and you only have one column with a default value and you...

Sorry... all the ORLY stuff got me going.. 🙂

Like this

SELECT

quartervalue = DATEPART(qq,datetimefield),

quartersum = SUM(salesvalues)

FROM

Sales_data

WHERE

datepart(yy,datetimefield) = somevalue

GROUP BY

DATEPART(qq,datetimefield)

Actually

since from BOL I found

By default, the UNION operator removes duplicate rows from the result set. If you use ALL, all rows are included in the results and duplicates are...

I don't have 3 billion record tables to test with but...

Wouldn't something like this work?

INSERT INTO TABLED

SELECT

main.col1

FROM

(

SELECT col1 FROM TABLEA

UNION

SELECT...

Thanks!

I had known of FOR XML EXPLICIT after having to write a 30 column 7 layer XML query to generate a sales order for Biztalk to pickup. This is...

Me too 🙂

Grant Fritchey (7/15/2008)

---

Well it sure doesn't work by default. I tried it in 2005 and 2008 and received nothing. I also note, that the answer, ALT-F1, is not listed in...

And if you try to next a subquery in the select portion of a query

i.e.

SELECT

howtojoin = (SELECT joinrequirements FROM requirements_table)

I will shoot you... 😛

Grant Fritchey (7/11/2008)

---

mtassin (7/11/2008)

---

Grant Fritchey (7/11/2008)

---

You know, either way...

Grant Fritchey (7/11/2008)

---

You know, either way works for me,...

I do remember it having a big impact on performance in SQL 7... though I never could figure out...

Grant Fritchey (7/10/2008)

---

I'm going to start digging, but I've had instances where moving filtration from the WHERE clause to the ON clause does change the execution plan. I don't have...

You join by fighting it in the streets... in the...

I too must agree with Grant... ANSI-92+ join syntax is easier to understand and much better in terms of self-documenting.