Viewing 15 posts - 46 through 60 (of 83 total)
Hi, Looked at link very good but still unclear how to do it... here is the sql
CREATE TABLE [TblClientPOC](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ClientID] [nchar](10) NULL,
[StartDate] [date] NULL,
[ApptTime] [time](7) NULL,
[Duration] [int]...
December 17, 2015 at 3:01 am
Hi Guys,
Yes there is a limit of either 1 week, 2 weeks or 4 weeks maximum.
So the user chooses an option 1,2 or 4 week period and 2 dates SDate...
December 17, 2015 at 2:07 am
Hi,
We are running on sql server 2008 r2 express, which I think doesn't have reporting service built in!
But once the output from the pivot table is correct I want to...
December 16, 2015 at 11:39 pm
Hey Steve,
Yes that was very helpful article. They make a good point if you add a windows user into a sql database they can then use other programs other than...
March 7, 2015 at 4:05 pm
Hi Steve,
Interesting read Steve.
I am testing niw on my database.
I have given my users just datareader and datawriter privileges.
Then I intend to create a database role called DB_SPUser with...
March 7, 2015 at 10:41 am
Hi Steve,
Thank you for the prompt reply. I was thinking roles might be the solution, but hadn't looked into it fully.
Cheers for the help.
March 7, 2015 at 10:17 am
Thank you for that info.
Your absolutely right I should use numeric as to avoid all sorts of rounding errors etc thank you.
I have decided to create a table to solve...
June 19, 2014 at 5:00 pm
HI Thanks for your prompt reply.
When I calculate the FinalOwedHours I need to bring it back into the calculation for the next month as PrvsOwedHours !
SO I am not sure...
June 18, 2014 at 5:28 pm
1234, 10/1/14, 42.75, 84.00
1234, 9/2/14, 11.25, 12.00
1111, 10/1/14, 10.50, 23.00
June 13, 2014 at 8:09 pm
output should be...
Output for each employee would be 1 row for each 4 week period as follows;
PersonnelNo, 4WeekEnd, TotalWorkedHours, TotalContractHours
1234, 1/10/14, 42.75, 82.00
1234, 2/9/14, 34.50, 82.00
4343, 1/10/14, 34.00, 74.00
June 13, 2014 at 1:02 pm
I think it should be something like
SELECT PersNo, 4WeekEnd, TotalWorkedHours, TotalContractHours
From
WITH TblWorkedHours @WeekEnd
(Select
PersNo,
Max(WeekEnding) As 4 WeekEnd,
Sum(WorkedHours) As TotalWOrkedHours,
...
June 13, 2014 at 10:00 am
Just for clarity its not lunar month, its a four week month...
June 13, 2014 at 9:53 am
Hi guys, thanks for all those kind words.
I suppose I am not articulating what the problem is, so here goes again.
I have a table with PersNo, WeekEnding, WorkedHours and...
June 13, 2014 at 9:51 am
That would be great...
Sample data would be
ID, PersonnelNo,WeekEnding, WorkedHours, ContractHours
4, 1234, 1/10/14, 10.50, 20.00
3, 1234, 23/9/14, 11.00, 20.00
2, 1234, 16/9/14, 10.75,...
June 12, 2014 at 4:23 pm
Hi,
Thanks for your reply, while I respect your opinion, the reasons you give not to use a View equally apply to Stored Proc. surely if a SP got dropped,...
June 3, 2014 at 5:02 pm
Viewing 15 posts - 46 through 60 (of 83 total)