Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2008-01-16 : 10:25:09
|
| Anyone have any ideas why this insert statement would hangthanks for your help INSERT INTO jb.SR_Rolledup_AVG (aibFK, Loc_FK, PartFK, US4WkAvg) SELECT @StartaibFK, Loc_FK, PartFK, CAST(ROUND([Avg4WkQS], 0) AS INT) [Avg4WkQS] FROM (SELECT F.Loc_FK, F.PartFK, SUM(F.QS - F.QU) / CASE WHEN CAST(WA.aibFK AS SMALLINT) - A.aibFK > 2 THEN 4. ELSE CAST(WA.aibFK AS SMALLINT) - A.aibFK + 1. END [Avg4WkQS] FROM dbo.entries F INNER JOIN jb.ATTRIBUTE A ON F.Loc_FK = A.Loc_FK AND F.PartFK = A.PartFK INNER JOIN dbo.WT_REPORTING WR ON A.TradingPartnerFK = WR.TradingPartnerFK INNER JOIN jb.WEEKS_TO_AVG WA ON F.aibFK = WA.InAvgaibFK GROUP BY F.Loc_FK, F.PartFK, WA.aibFK, A.aibFK) AS A; |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2008-01-16 : 13:44:30
|
| you'll need to look for blocking, start with sp_who2. what happens if u execute the select part alone (without the insert)? |
 |
|
|
|
|
|
Insert hangs