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...

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...

suggest you start here

https://technet.microsoft.com/en-us/library/ms170207(v=sql.90).aspx

kame707 (9/20/2015)

---

thanks;but i want when i run the query it should ask me give the month and batch no.after giving the month and batch no thn it should display the...

kame707 (9/20/2015)

---

I have a tabel name tbl_fr

it has several fields

[mr_recno]

,[bill_month]

,[batch_no]

...

Kristen-173977 (9/19/2015)

---

Personally I prefer modern forums software, like Xenoforo (Discourse has some of these features too). WYSIWYG AJAX editors, highlight text in any post for a "quote this" button, drafts...

Joe-420121 (9/19/2015)

---

Hello Wayne,

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...

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...

as a pointer....why not try dumping your data into a temp table and then...

rkelly58 (9/18/2015)

---

Hi,

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...

rkelly58 (9/18/2015)

---

Hi J,

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...

yeah..I see that

how did you get on with the code I gave you?

rkelly58 (9/18/2015)

---

Hi,

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...

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...

rkelly58 (9/17/2015)

---

Hi,

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...