Almost same solution posted here...

http://www.sqlservercentral.com/Forums/Topic929079-145-1.aspx

How many scores are you expecting against Each user. Ist it 5 or Less / More than that?

I think problem is here;

UPDATE SOAllocation

SET sa.SMFixed = (ar.disbursementValue/(Select c.counts

FROM temp1 c

Where c.counts=114))

From

SOAllocation sa INNER JOIN

SOStagingTable ss ON sa.SO = ss.SO AND sa.FiscalYear = ss.FiscalYear

AND sa.DriverTimeFrame = ss.DriverTimeFrame...

Do you want same EMployeeID from desktop Application and Web Application? WHY?

I hope you dont mind dynamic sql...?

CREATE TABLE #mytable

(

ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, --Is an IDENTITY column on real table

MACHINE_ID NVARCHAR(32),

TOOL_ID NVARCHAR(32),

ONHAND INT,

COLOR NVARCHAR(32)

)

--===== All Inserts into the...

You can check the new requirement with the same query. Execute the query with @vVarTime variable first with StartTime and then with End time (or use OR operator in the...

Its just to check the multi dated shift and its end time. you can use variable here.

Declare @vShiftTable Table (ShiftID int, startTime datetime, endtime datetime)

Declare @vVarTime datetime

Declare @vMultiDateTime datetime

declare @start...

OK. Let me give an example.

I have one tblEmployee table with EmployeeID as Primary Key and another column DepartmentID.

Another tblDepartment with DepartmentID as Primary Key and another column...

Is there still any problem in solution I posted? I thought you got the exact results?

GilaMonster (5/30/2010)

---

Truncate only was...

Glad it worked.

Sorry for...

David Portas (5/28/2010)

---

As Ron says, it's not necessarily wrong from a logical perspective. In fact, relationships of this kind which are mandatory in both directions are perfectly common in data...

I have submitted a script to accomplish this task. plz comment to make it meor efficient.

http://www.sqlservercentral.com/scripts/Stored+Procedures/70363/

I assume the answer to my question is 2.

Try this;

Select * from (

Select a.Machine_ID, a.TOOL_ID as Col1,IsNull(b.TOOL_ID,'') as Col2, Row_number() over (partition by a.Machine_ID order by a.Machine_ID) as rno

from #mytable...

Is there any defined limit of MachineID in #mytable?