if this is the code you intend to use http://sqlindia.com/generate-table-definitions-using-tsql-sql-server/ then please see below

CREATE TABLE [dbo].[TableTest](

[inta] [int] NOT NULL,

[intb] [int]...

did this get resolved?

same post on SO

http://stackoverflow.com/questions/35263844/calculate-total-salary-based-on-employee-type

Jacob's solution gives what you have asked for...however I am wondering how you hold your payrates?

currently you have a four month spread for your query with a single payrate for...

if I run the sample scripts and then run this query

SELECT t_mcno, t_citg, t_trdt, t_shft, t_wght

FROM ...

as previously mentioned to you...please provide scripts...thanks

http://www.sqlservercentral.com/Forums/FindPost1756729.aspx

no joy with that link...fails to load

why should Judes pay be 20269.25...there were no sales for Jude (If I understand you...

EDIT please read the following...it will help you help us help you.

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

as a start. , based on the info provided so far by the OP. here is...

Raxter (2/7/2016)

---

I added the DDL statements to create tables. I apologize for not supplying all the needed information. I am new to this site but will make sure in the...

probably because you are using MySQL....this forum is MS SQL orientated.

can you clarify your understanding of "average"

here is a starter doc for your further thoughts

http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/it-s-hard-to-be/

silverbullettruck (2/3/2016)

---

Here's the situation with the LOB = MNS. MNS has two different properties for the XLOB (ML and MS), for those two different XLOB values there are differing...

ChrisM@Work (2/3/2016)

---

silverbullettruck (2/3/2016)

---

Yes, it would be ok to switch values for the values that exist multiple times for the same LOB with different values, but the values that only exist...

ok, I know the following isnt the solution you have requested.

But I am struggling to come up with a solution that exactly matches your requirements, I hope someone else...

silverbullettruck (2/2/2016)

---

Can we push the reset button? I think I derailed people by mistake. Here's a smaller set of data and a before and after of the result...