Viewing 15 posts - 1,066 through 1,080 (of 2,452 total)
And please consider my suggestion to NOT ADD or DELETE rows across the database file system directly, but indirectly, then ADD AND DELETE them directly just before a periodic (say...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 21, 2015 at 1:35 pm
try this
with roomhours (hour_number ,hour_description) as
(
SELECT 0, '12 am' UNION ALL
SELECT 1, '1 am' UNION ALL
SELECT 2, '2 am' UNION ALL
SELECT 3, '3 am' UNION ALL
SELECT 4, '4 am' UNION...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 21, 2015 at 9:51 am
kame707 (9/20/2015)
i m writing this query in SQLCMD.EXE to retrieve data.
suggest you start here
https://technet.microsoft.com/en-us/library/ms170207(v=sql.90).aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 20, 2015 at 11:59 am
kame707 (9/20/2015)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 20, 2015 at 11:30 am
kame707 (9/20/2015)
it has several fields
[mr_recno]
,[bill_month]
,[batch_no]
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 20, 2015 at 10:19 am
Kristen-173977 (9/19/2015)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 19, 2015 at 12:25 pm
Joe-420121 (9/19/2015)
How to UNPIVOT the same with string Length of 5? I need get back to its original form (UNPIVOT) but with size of 5 characters. Could you help...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 19, 2015 at 12:08 pm
assuming you have created the "roomhours" table
then something akin to this should work ....
with cte as (
SELECT Description, StartDateTime, EndDateTime, Name
FROM (SELECT data.V_ACTIVITY.Description, data.V_ACTIVITY_DATETIME.StartDateTime, data.V_ACTIVITY_DATETIME.EndDateTime,
data.V_LOCATION.Name
FROM data.V_ACTIVITY INNER JOIN
data.V_ACTIVITY_DATETIME ON...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2015 at 11:31 am
rkelly58 (9/18/2015)
No worries about the Reporting Services part.Could you still help with combining your query into mine?
as a pointer....why not try dumping your data into a temp table and then...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2015 at 10:58 am
rkelly58 (9/18/2015)
Yes that's the code.
It pulls out 140,000 rows. -This is data with bookings for "all" rooms
On the Reporting Services, I have parameters called StartDate (this is the date the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2015 at 9:16 am
rkelly58 (9/18/2015)
I tried your code and the results are exactly like I want. -You make that look so easy!!!!
How do I add your query to my existing query to...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2015 at 8:49 am
rkelly58 (9/18/2015)
P.S. i;ve added a bit more info to my above post
yeah..I see that
how did you get on with the code I gave you?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2015 at 7:33 am
rkelly58 (9/18/2015)
Firstly my sincere apologies for not posting according to the guide, I hadn't realized when joining that you guys would response, let alone help me with this, so i'm...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2015 at 4:24 am
a few more questions if I may please......
I appreciate that you are new here so:
I recall seeing similar questions at this time of year when a new semester starts.....is...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 17, 2015 at 3:58 pm
rkelly58 (9/17/2015)
I'm new to SQL and am facing a query which I don't know how to write SQL for...
I need to display at what hours rooms are booked in each...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 17, 2015 at 10:32 am
Viewing 15 posts - 1,066 through 1,080 (of 2,452 total)