Viewing 15 posts - 886 through 900 (of 2,452 total)
mw112009 (2/12/2016)
Sean:Here you go:
Whether it is accurate or not.. Your decision
http://sqlindia.com/generate-table-definitions-using-tsql-sql-server/
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]...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2016 at 4:35 am
did this get resolved?
same post on SO
http://stackoverflow.com/questions/35263844/calculate-total-salary-based-on-employee-type
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 9, 2016 at 11:54 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 8, 2016 at 2:16 pm
if I run the sample scripts and then run this query
SELECT t_mcno, t_citg, t_trdt, t_shft, t_wght
FROM ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 8, 2016 at 1:26 pm
as previously mentioned to you...please provide scripts...thanks
http://www.sqlservercentral.com/Forums/FindPost1756729.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 8, 2016 at 11:34 am
coolcurrent4u (2/8/2016)
Hellosee an sql fiddle http://sqlfiddle.com/#!3/f4be2/1
Regards
no joy with that link...fails to load
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 8, 2016 at 9:22 am
Take note of Judes pay which is 20269.25 rather than 20000 in the previous table
why should Judes pay be 20269.25...there were no sales for Jude (If I understand you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 8, 2016 at 8:59 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 7, 2016 at 2:07 pm
Raxter (2/7/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 7, 2016 at 7:50 am
GaffneyJ (2/7/2016)
Bump, still no resolution to this
probably because you are using MySQL....this forum is MS SQL orientated.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 7, 2016 at 4:48 am
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/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 4, 2016 at 12:46 pm
silverbullettruck (2/3/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 3, 2016 at 10:41 am
ChrisM@Work (2/3/2016)
silverbullettruck (2/3/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 3, 2016 at 8:58 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 3, 2016 at 8:17 am
silverbullettruck (2/2/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 3, 2016 at 6:22 am
Viewing 15 posts - 886 through 900 (of 2,452 total)