Viewing 15 posts - 1,051 through 1,065 (of 2,452 total)
rkelly58 (9/25/2015)
Just been trying the script out and it looks good. Had a warning about not having permissions to create Table, but it ran ok.
Can you please change the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 25, 2015 at 5:52 am
try this as a start....it should give some ideas on how you can now move on.
I have broken each step out into separate ctes to make it clear what is...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 24, 2015 at 5:17 am
rkelly58 (9/24/2015)
This took me ages, but here you go.... phewDataset 1 Sample Data (Logins)
@StartDate was 21/09/2015
@EndDate was 22/09/2015
Sorted Data and pulled out sample data for Room L1.03
ok....did you try running...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 24, 2015 at 3:49 am
Alvin Ramard (9/23/2015)
erichansen1836 (9/23/2015)
have you heard about SQL Developer edition?
SQL Server 2014 Developer Edition lets developers build almost any kind of database application on top of SQL Server. It's licensed...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 23, 2015 at 3:34 pm
erichansen1836 (9/23/2015)
have you heard about SQL Developer edition?
SQL Server 2014 Developer Edition lets developers build almost any kind of database application on top of SQL Server. It's licensed for use...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 23, 2015 at 2:51 pm
SOMEONE is going to want a 5 Billion row database they can work with just by themselves as part of their job duties, and located/maintained by them on their own...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 23, 2015 at 2:13 pm
erichansen1836 (9/23/2015)
Hi Eric...hope you are well
am trying to understand what you are proposing ....I get the impression that what you deliver is a "write once/ read many" scenario......as opposed to...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 23, 2015 at 12:21 pm
erichansen1836 (9/23/2015)
Sounds like this would take a lot of programming and testing before it could be considered safe and reliable. So much for your earlier comment saying this would require...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 23, 2015 at 11:18 am
rkelly58 (9/23/2015)
SELECT MachineLocations.CampusID, MachineLocations.Campus, MachineLocations.BuildingID, MachineLocations.Building, MachineLocations.RoomID,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 23, 2015 at 8:36 am
rkelly58 (9/23/2015)
sorry bout that, I wanted to see if the code was properly formatted before posting the rest of it.No more edits to it now 🙂
me thinks it will...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 23, 2015 at 7:56 am
edit...deleted
seems you were posting at same time as I was.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 23, 2015 at 7:44 am
rkelly58 (9/22/2015)
Me again, this works great. As part of my back story, I mentioned PC logins also need to be included in the hour slots.
Is there a way to...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 22, 2015 at 10:32 am
rkelly58 (9/22/2015)
Thank...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 22, 2015 at 7:39 am
rkelly58 (9/22/2015)
I just tried adding ORDER BY r.hour_number to the end, and it works FINE in...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 22, 2015 at 7:25 am
try
ORDER BY r.hour_number
....and I wasn't "barking" 😀
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 22, 2015 at 5:54 am
Viewing 15 posts - 1,051 through 1,065 (of 2,452 total)