sorry the table creation script is bit wrong, it should have been float instead of int.
Create table Sales
(
Id int identity (1,1),

OrderID int,

ProductName varchar(50),

THOM Query

SELECT
--'[ID1411]' +','+ cast([DayDateKEY] as nvarchar(500))+':'+cast([Half Hour Start Time] as nvarchar(500))+', '+cast(count(I.[Call Number]) as nvarchar(105)) as ID
from dimdate dates --on dates.DayDateKEY = i.[Call Date DayDateKEY]
cross apply DIMtime...

Hi

Yes, ID-1411 is not a field from fact table, its a string, I trying to get output with along with string and also the date condtion is on...

Thank you ZZartin, I am glad for your reply. It helped me.

HI Thom, Phil,

Sorry I was on holiday from Friday, I just came back to today morning, I have just checked how to post the data. I am glad...

Hi,

I am glad for your replies, to be prescise I am looking to achieve the following example

The sample script would be like and we...

Hi, 

The sample script would be like and we do have primary keys and foreign keys on Fact Table.

select 'US' As CountryIndicator, sum(MoneyReceived) MoneyReceived, getdate() DateTime

I am sorry I would have inform early, For simplicity I have written the dates as 8th Feb, 9th Feb, but In my Fact Table and Date table we have...

Hi, I am glad for replies, this is an example of requirement but I need to achieve the same thing for every 15 minutes, what is the updated count between...