Reading Kimball's book on Data Warehousing isn't a bad place to start. It's a great introduction to the concepts in DW design and modeling. But it's definitely true...

I did it with a Matrix report.

Row: ProductDate

Column: PersonName

Intersection (value): ProductName

or did it have to be in query?

I think that will work. I knew I had to be making it waaay harder than it really was.

Thanks!

omid.shokri (7/7/2013)

---

Thanks for reply.

This query is the part of a procedure.

I think no different these two query, but output of query 1 is without any row. In other word, "Inner...

Is this homework? When you ran it, did you notice any differences?

OUTER joins show all the records from the LEFT table, and matches or nulls in the right side...

Could be me, but I think you're making this infinitely harder than it really needs to be. If you think in terms of SETS and use pure SQL, you...

This worked for me... (FWIW)

insert into temp (id, strg, [index])

values (1, 'abc', 1);

declare @strg varchar (5)

select @strg = case when ID = 1 and [INDEX] = 1

then strg

else cast(0 AS...

Look harder, young Jedi!

[/url]

Actually, a point in time restore is probably the best option... I was thinking that the damage had not already been done - but if it has, that's your best...

Yes, you could, but that's like killing a mosquito with a bazooka. Wrapping the statements in question in a transaction would be much less overhead and work.

probably sp_sendDBMail and jobs. Definitely not triggers.

not much to go on...

what kind of message? Based on what? Service Broker might be a solution.

I'm a recovering Access developer, so my opinions may help you (and may well not).

Anyway, Access is good for prototyping and front ends (if you cannot use ASP.NET or VB.NET...

This design:

CREATE TABLE #TestTb1 ([Sample_ID] VARCHAR(10), [P1] INT, [P2] INT, [P3] INT, [P4] INT)

is going to bite you. I would strongly recommend not doing that. (I worked on...

Wrong design.

CREATE TABLE Test(

PatientID int,

TestID int,

Reading decimal(10,4)

TestDate DateTime

);

Then the rest is trivial.