PaulB-TheOneAndOnly (1/16/2012)

---

Please do not take it the wrong way but, out of curiosity, why is the subject of this thread "my favorite normalization case study" if you never intended to...

PaulB-TheOneAndOnly (1/16/2012)

---

Would you mind in writting a query to answer the question... "Did Peter Bishop attend Particle Physics 501 on January 9th, 2012?"

Now... write a query to answer the same...

PaulB-TheOneAndOnly (1/14/2012)

---

patrickmcginnis59 (1/13/2012)

---

Long story short, I used an array of characters and a nice scrolly matrix gadget with dates across the top and students down the side, the whole matrix...

bevans 97934 (1/7/2012)

---

I unfortunately can only access the database again on Monday.

I'm not sure how much of it you understood, but someone suggested that there is no need at all...

SQLKnowItAll (1/16/2012)

---

patrickmcginnis59 (1/16/2012)

---

SQLKnowItAll (1/16/2012)

---

HINT: Look at the data types for the columns you are doing the difference of. Are you sure that the difference can be negative based on...

SQLKnowItAll (1/16/2012)

---

HINT: Look at the data types for the columns you are doing the difference of. Are you sure that the difference can be negative based on those data...

mrwillcostello (1/14/2012)

---

ok let me rephrase I know how to do the query. the problem is I can't figure out how to get the negative numbers.If there is no profit it...

Maybe your MSDTC service is firewalled between the two servers?

Can you do any distributed transaction at all?

How about...

venu9099 (1/13/2012)

---

Create Trigger jam_spu_csp_insert

on dbo.customer_special_prices

After Insert

AS

Begin

Set nocount on;

insert into jam_spu ( customer_id, location_number, seq_num )

values ( new_name.customer_id, new_name.location_number, new_name.seq_num )

end

go

error

Server: Msg 128, Level 15, State...

venu9099 (1/13/2012)

---

create trigger jam_spu_csp_insert

on customer_special_prices

for insert

as

referencing new as new_name for each row

begin

insert into jam_spu ( customer_id, location_number, seq_num )

values ( new_name.customer_id,...

I don't as a rule open word documents from the web because I don't trust antivirus software to do its job that I paid perfectly good money to them to...

These are all open questions. If a reputation is by number...

I remember growing up thinking how advances in the sciences, arts and humanities and intellectualism in general would lead to a sort of human nirvana, when the worlds problems would...

Windows Workflow Foundation!

I googled a section or two from your stored procedure and thats what it looks like. We should hope Microsoft's product is nice enough not to mess your...