Viewing 15 posts - 61 through 75 (of 83 total)
Hi,
I have my stored procedure working alright, thanks to everyone who contributed, but then I tried it a different way, I created a number of different views and joined them...
June 1, 2014 at 7:58 pm
Hi David,
Thank you so much for your answer, it looks like it will fit the bill alright
I just have one amendment I cant be sure that the dates in the...
May 28, 2014 at 3:55 pm
Hi Guys, Thanks for all the excellent idea's.
On further thought and examination of my needs , I think I need a stored procedure in which I pass in a...
May 28, 2014 at 3:49 am
Hi Guys, thanks for your reply, it looks like something that would work the bill.
Everything was going grand until I read
DENSE_RANK() OVER( PARTITION BY WeekEndingDate ORDER BY customersID) -...
May 27, 2014 at 5:29 pm
Hi MM,
Thansks for your suggestions.
Thats what I was thinking myself a calendar table with just 2 columns something like...
MonthID, WeekEndate
1 , ...
May 26, 2014 at 5:07 pm
Hi,
Thanks for your prompt reply.
I think the data is very simple really.
ClientID's are Integers
WeekEndingDate is a date , there is 52 weekly dates for each Client.
WorkedHours is a Double
I want...
May 26, 2014 at 4:33 pm
Sorry sturner,
perhaps i have not explained it enough, the task id and the client id must go into the same field in the hours worked table, because staff are...
November 7, 2011 at 6:22 pm
Hi L' Eomot Inversé,
I agree, whenever I see null entries in a table I think 'poor design!'
A null tells you nothing, take a simle example like tblGender , with Male...
November 4, 2011 at 10:05 am
Thats what I am asking is it normal practice.
There would be more than 1 task/organisation id to find as the task that the staff member is being paid for, this...
November 4, 2011 at 8:25 am
Hi John & sturner,
John's way is what I believe to be the standrard way, adding non client data to the tbl Client, but surely this breaks the rules of data...
November 4, 2011 at 8:05 am
Hi,
Good advice was reappraising the size of tables and I think one table could have 500,000 records after 5 years.
But still think the free version of Sql server will do...
October 31, 2011 at 7:59 am
Yes green and wet behind the ears!
But maybe i didn't explain it right i am familiar with the object orientated programming paradigm, i understand the principles behind encapsulation too.
I...
October 26, 2011 at 5:56 pm
Hi
I currently login in as admin which has sa right and everything works perfectly but the error still arises everytime I open ssms!
Excuse my ignorance should i connect as sa?,
October 20, 2011 at 5:14 pm
Hi SSCoach
Can you explain a little more, excuse my.igborance but what do you by objrct do you mean recordset type? or table?
Kind regards
😀
October 20, 2011 at 5:10 pm
No thank you.
But now that I can view my tables, my next questions is how do I update my records !
I think I would do one at a time but...
October 18, 2011 at 3:48 pm
Viewing 15 posts - 61 through 75 (of 83 total)