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.

Big topic. You might want to start by looking up partitioning. Do you need to keep some of the records in the table "active"/editable while others are not?...

You could also do this in Reporting Services with a Matrix...

did you back up and restore MSDB from your old server to the new one? that's where the jobs are stored.