picant (1/16/2011)

---

Of course there is...

picant (1/16/2011)

---

> ...Based on what you have provided, I use a CROSS JOIN, but that would result in 6 records...

6 records are not good. For the given data statement should...

You could also use this:

with MonthNumbers as (

select 1 as MonthNum union all

select 2 as MonthNum union all

select 3 as MonthNum union all

select 4 as MonthNum union all

select 5 as...

paul.beattie (1/16/2011)

---

That's it.

During all the complicated things I've tried, I had this deep-seated feeling there was an easy, elegant answer out there somewhere - which of course just made me...

I think I have seen this before when you attempt to access an article before its actual publication date.

Gift Peddie (1/16/2011)

---

Lynn Pettis (1/16/2011)

---

First, I wasn't the only one to suggest hiring a DBA or consultant.

Second, the OP also indicated that they could possibly use SSIS to...

mohammad.shamim 40895 (1/13/2011)

---

Dear All ,

i have face below problem for linked server pleaser help me asap

OLE DB provider "SQLNCLI10" for linked server "XLTEST_SP" returned message "Login timeout expired".

OLE DB...

If you can, I'd restore the database to another server and run DBCC CHECKDB and see what errors it may find. This would be the first step in identifying...

From the description of the problem, no. Can you show us what you are trying to accomplish?

Can you provide the DDL (CREATE TABLE statements) for the table(s), some sample data that is representative of the problem you are trying to solve, and the expected results?

All of...

Not really sure what you are attempting to accomplish. Perhaps if you show the flow of the data between the databases, and the interactions that occur between databases and...

j2bmw (1/13/2011)

---

Let’s say we have 3 tables: fruit name, color and taste that have data like this:

Fruits:

Apple

Color:

Red

Green

Yellow

Taste:

Sweet

Bitter

I need to come up with a single SQL statement that will combine all...

GilaMonster (1/16/2011)

---

Considering how active (not) a sunday night is, it's not hard to...

First, I wasn't the only one to suggest hiring a DBA or consultant.

Second, the OP also indicated that they could possibly use SSIS to pull data from other...

I highly agree with what has been said when it comes to licensing, consult your MS...