Krishna1 (6/25/2013)

---

Dear All

I have folloing query

select sum(yy) sumyy, 'summary line' xx

from tablea

where somedate_column < @startdate_parameter

union

select yy, xx

from tablea

where somedate_column between @startdate_parameter and @enddate_parameter

Is there a better way to achive this...

If the databases are on the same server you can do this by using the full naming convention.

[database].[schema].[object]

If they are on different servers you will need to setup link...

duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1467443-1633-1.aspx

paul.knibbs (6/26/2013)

---

I would tend to...

Stefan Krzywicki (6/26/2013)

---

Fal (6/25/2013)

---

I put mine in the oven.

And sometimes I accidentally do one when I put it through the wash...

dob111283 (6/26/2013)

---

Sean, maybe because I'm having trouble understanding between TOP and OFFSET-FETCH. I know OFFSET FETCH was added to sql 2012 and I forget what the benefits are, I just...

To add another reason for not storing dates as integers, doing any kind of date math means your queries are going to be slower. Just look at the simple example...

Just because you CAN...

Thanks again for posting your data. It all seems to be fine now. 🙂

I am at a bit of a loss as to the logic here. I can't seem to...

No kidding. One...

There are probably some other ways to do this but this should work.

with E1(N) AS (select 1 from (values (1),(1),(1),(1),(1),(1),(1),(1),(1),(1))dt(n)),

E2(N) AS (SELECT 1 FROM E1 a, E1 b), --10E+2 or...

Nick, I was merely trying to help my fellow posters not waste a lot of time like I did just a day or two ago trying to extract enough information...

That is probably your best bet. Without...

oradbguru (6/25/2013)

---

Hello, I have the following query and I need the results in 1 row going across. Here is the query:

SELECT top(5)

ap.apptDte,

...

I have a feeling this thread is going like the last one from the poster. http://www.sqlservercentral.com/Forums/Topic1465520-391-1.aspx

Lots of completely vague posts and suddenly, voila! The OP posts a complete random lengthy...