....

I suggested the same thing you mentioned to the person who created these tables. However, I got the reply that this was out of question and I have to proceed...

You would greatly benefit if you could normalise your Staff table.

I would suggest to get MonHours, TueHours etc. out of this table and place it into dedicated StaffWorkHours table which...

I can see the problem. Please wait for few minutes.

Paul, let start from making your query a bit more readable.

1. You can use DATENAME function instead of converting month number to string.

2. You don't need check if "datepart(mm,s.[Date]) IN...

Base on limited details posted...

Contacts = CONVERT(VARCHAR(8), EventDate, 112)

+

...

Would you be able to post DDL and data setup not as attachments? Many workplaces do prohibit downloading from web...

Welcome to the best SQL Forum on earth!

In order to help you we will need a bit more details from you.

Table's DDL, some sample data (as insert script) and...

never heard more stupid question!

at the end it depends on pc power.

exec @test-2 = ActualizaStock

Use TRY ... CATCH

If you want everything undone when the error happens do everything within one TRANSACTION

It's not, just this huge set of sum's and brackets on Friday did make me dizzy. Time for a pint!

😀

... was able to achieve this with code:

convert(int,((sum(datepart(hour,Timenetin) * 3600) + sum(datepart(hour,cat2_hours) * 3600) + sum(datepart(minute,Timenetin) * 60) + sum(datepart(minute,cat2_hours) * 60) + sum(datepart(second,Timenetin) * 1) +...

vinu512 (4/27/2012)

---

Jeff Moden (4/27/2012)

---

vinu512 (4/26/2012)

---

But the requirement is that I do not need the Names as a "Set". I need them separately(one by one), so that I can use them...

jwmott (4/26/2012)

---

Is their a slick way that I can check the condition of a field and return multiple discrete fields like a begin end block in a select statment

select...

Which one?