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...
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...
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...
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...
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...
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...
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...
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...
September 23, 2015 at 11:18 am
rkelly58 (9/23/2015)
SELECT MachineLocations.CampusID, MachineLocations.Campus, MachineLocations.BuildingID, MachineLocations.Building, MachineLocations.RoomID,
...
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...
September 23, 2015 at 7:56 am
edit...deleted
seems you were posting at same time as I was.
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...
September 22, 2015 at 10:32 am
rkelly58 (9/22/2015)
Thank...
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...
September 22, 2015 at 7:25 am
try
ORDER BY r.hour_number
....and I wasn't "barking" 😀
September 22, 2015 at 5:54 am
Viewing 15 posts - 1,051 through 1,065 (of 2,452 total)