Okay, so you have SQLExpress installed, which is kind of what I thought. The next step is to go into SQL Server Configuration Manager -> SQL Server Network Configuration...

It really doesn't matter what directory the files are in as long as they are in the location specified in your CREATE DATABASE statement which they are. The only...

Did you follow the instructions for installing and attaching the database, found here, http://social.technet.microsoft.com/wiki/contents/articles/3735.sql-server-samples-readme.aspx?

No. Reporting Services Configuration Manager isn't part of designing a report. Can you attach the report definition file (.rdl) to the thread? You attach files using post...

drew.allen (7/15/2015)

---

This is essentially an islands and gaps problem with the added wrinkle that the '@@@@@' records are counted in both the islands and the gaps. I used a...

Steve Jones - SSC Editor (7/15/2015)

---

Lynn Pettis (7/15/2015)

---

So, we are now in mid July, should I start looking at airline and hotel reservations for the Summit?

Not as concerned about getting...

traczek2 (7/15/2015)

---

How do you know that the data source is not pointing to the correct database?

Because AdventureWorksDataset has no "+" to expand and see the contents of the files (tables).

Also,...

ZZartin (7/15/2015)

---

If needed change the select to 😀

SELECT CUR_COL_ONE, COL_VALUE, ROW_NUMBER() OVER(PARTITION BY PAR_COL_ONE ORDER BY CUR_COL_ONE) AS SEQ_NUMBER FROM TEMP_CTE_TWO

UNION ALL

SELECT COL_ONE, COL_TWO, 0 FROM #test WHERE COL_TWO =...

This query is logically an INNER JOIN because...

Just saw this recently when using a loginless user using EXECUTE AS. Could be that this is what is happening.

You can verify using this:

CREATE USER test WITHOUT LOGIN;

GO

EXECUTE AS...

But you aren't returning the '@@@@@' columns that are in the set.

There are many possible reasons for this including:

1. Much more data in the table(s) being accessed in database2

2. Database2 being on a different server and not having as many resources

3....

How do you know that the data source is not pointing to the correct database?

What is the connection string you used?

Based on the example in this BOL Article, I'd say varbinary(128).

Do you need to do it at insert or is it an update AFTER the rows are inserted?

It is possible to do it in both cases. Seems like an...