Matt,

I didn't think you could use an Instead Of Trigger like that. I thought that if I chose an "Instead Of" trigger that the action supplied by that triggger would...

tbeadle,

Thanks for the reply. I never thought of a unique combo index. I guess that would work the same as a constraint though? Wouldn't it?

In this case the uniquness only...

Serigy,

Thanks for the reply everyone.

The problem is this unqiue data enforcement only applies to one RefType in the table, not all of them. If I understand Unique Constraints correctly what...

Gila,

I was wondering about that. I almost tried it for the heck of it but I figured you'd have to supply a BEGIN TRAN somewhere which I wasn't so I...

I sort of did that with the report that contains only the one week of data. Because I know the report runs on only Saturda I subtract 7 days from...

Week of the year as defined by SQL datepart(wk,Date).

I'll be running a call count report by week and each day from that week for sales agents. I made a Cross...

I edited my post so the data would appear on each line instead of looking like it was tab delimited.

Actually this file would only contain that amount of data. It...

Hey Matt,

If we keep running into each other like this your just going to have to give me your phone number!

It's a txt file. It's a little different than a...

Thanks for the links... I'll check em out.

The weird thing is the Rows are all terminated with the ^

Not sure how that'll afffect it. I'll read about it....

Thanks for the info.

Unfortunately I haven't had any luck with the updating. Maybe it's just a caveat of that type of Cursor. The update is called it just won't...

I'll get you some more details. I have plenty of cursors that operate with the same logic so if I can figure out how to eliminate this one I'm sure...

Trader Sam... I haven't run profiler yet but I'll try that. The update runs but it just doesn't actually update that row. I mentioned earlier that I did a blanket...

Thanks for the replies.

I have some questions but they'll have to wait until after a conference call I have. Thanks again.

Okay I trimmed the proc down and included only the cursor portion so it was a little less lengthy.

--Get BatchControl Number

BEGIN

INSERT INTO t_210_BatchControl (Customer,BatchStatus) VALUES (@CustomerName,'Gathering Invoices')

SET @ControlNumber =...

Okay you asked for it!!!! 🙂