Something similar to this Jeff?

The report server is working absolutely fine, it's only when i attempt to edit the report in Report Builder that I have a problem. The reasoning behind looking at...

Captain

Emptiness

I'm looking for a replacement for an 80gb iPod classic. I want something on which I can hold all my music and because that's approaching the 80gb mark getting...

shirish1987 (6/11/2015)

---

Hi,

I have one table NewsEntities which contains one to many relationship.ie. One NewsId can have multiple EntityId.

Consider,NewsId=1 has two entities with EntityId 1 and EntityId 2 .there multiple newsid...

As the others have said, I ran the scripts and, as expected, I got an error about the violation of the primary key constraint. I couldn't see anything about...

mpdillon (6/9/2015)

---

Here is a CTE query

With mstrTable(ItemNo, Sales)

as (

Query1

Union All

Query2

)

Select Row_Number () Over(Partition by ItemNo order by ItemNo)as RowNo, ItemNo, Sales

From mstrTable

order by ItemNo

The results from Query1 and Query2...

Crete

Hugo Kornelis (5/28/2015)

---

Okay, I am going to contest this one. I know that Books Online says that "Aggregate" can be "a logical operator or a physical operator". But who has...

Oh very funny...

Does it say anywhere to select two answers? I only selected one answer and got it wrong because two were required?

Edited because Mighty answered the question I actually asked...

We've recently moved from an aircraft hangar of an open plan office to a much smaller open plan office. There's definitely differences between the two. The smaller place...

Dwarfs, limited for growth. I see what you did there...

Humanoid