Perhaps you can do it without the third table:

select

coalesce(june.level, july.level) as 'level'

, coalesce(june.sthdi_code, july.sthdi_code) as 'sthdi_code'

, coalesce(june.Functional_Area, july.Functional_Area) as 'Functional_Area'

, coalesce(june.Quantity, 0) as 'Qty_june'

, coalesce(july.Quantity, 0) as 'Qty_july'

, coalesce(july.Quantity, 0)...

Yes, it's possible!

But when the transaction inside the stored procedure is rolled back, it will state an error message: "Transaction count after EXECUTE indicates a mismatching number of BEGIN and...

Can you post the error message from the logging/job history?

All your variables in your query are declared with a NVARCHAR datatype....

It's not really clear what you want, but I think you can put the GROUP BY statement inside the second sub-select (and remove the "q1" alias within this GROUP BY)

You have to remove column [attendence] from the GROUP BY because you are aggregating these values with the MIN statement.

JAMMOD (7/17/2013)

---

- Full DB Backup (Once Before Working Hours, Once During Working Hours, Once After Working Hours)

- DB Differential Backup...

Homework assignment?

Just use a GROUP BY in combination with a MIN statement.

I agree that it won't break your LOG chain, maybe I used...

I use this script to list all auto-growth events. It will summarize the number of times it happened and includes the oldest time and most recent time. The second select...

One more point to keep in mind: the sub-selects must only return one single row. If more rows are returned, the insert will fail. You can use the SELECT TOP...

As Koen allready pointed out, you need to use a single SELECT statement to insert the values. You also made some errors declaring he variables. Below is the working code....

There is not enough information to answer your question.

You say there are stored procedures and triggers involved. So you have allready a clue to how the data is entered. Take...

Any full backup will break the LSN chain, unless it's executed with the COPY_ONLY option. But this breaking of the LSN chain only applies to the DIFF backups. If you...

In my experience this is most time the cause of the error. The login of...