Yes there im using...

Hi ! Thank you Koen !

But in that example i dont have an option to have a...

Hi Kindly let me know 'how to add domain account used to calll the SP (calling sp_send_dbmail) to the Server as a login'

I dont understand what should be done ......

Kingston Hat off !

only wen i running the query by now , i come to know about your point and came to search this thread..

Thanks a LOT for you ...

And...

Yes Kingston it does work...

Thanks Kingston ! for such good explanation ... it really helps me to understand better the query .. ThkQ !!

Abhijeet Chavan (12/28/2010)

---

Some changes

DECLARE @CYBeginDate smalldatetime, @CYEndDate smalldatetime,

@LYBeginDate smalldatetime, @LYEndDate smalldatetime

select @CYBeginDate = dateadd(year, datepart(year, getdate()) - 1900, '1900-04-01')

select @CYEndDate = dateadd(day, -1, dateadd(month, 12, @CYBeginDate))

select @LYBeginDate = dateadd(year,...

Nakul Vachhrajani (12/27/2010)

---

Is this what you are looking for?

DECLARE @CYBeginDate VARCHAR(10)

DECLARE @CYEndDate VARCHAR(10)

DECLARE @LYBeginDate VARCHAR(10)

DECLARE @LYEndDate VARCHAR(10)

DECLARE @CYDate DATETIME

DECLARE @LYDate DATETIME

SET @CYDate = GETDATE()

--Test Data

--SET @CYDate...

Sorry i didn't get you.

Actually the query willo be run at any time and it has to take care by itself to result with the current yr data and Previous...

Yes , me too tried to find out, but not got the answers,

http://www.google.co.in/webhp?rls=ig#hl=en&expIds=17259,18167,27926,28066,28104&xhr=t&q=Different+types+of+SSAS+Cube+Deployment+&cp=28&pf=p&sclient=psy&rls=ig&site=webhp&aq=f&aqi=&aql=&oq=Different+types+of+SSAS+Cube+Deployment+&gs_rfai=&pbx=1&fp=4e5f7bc786d2f00e

i guess only 1 type. right click --->; Deploy,

Else deploy alone not processing... is this...

hi Any help please !!!

hi im getting the following error please help me..

Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_Good_x0020_Will_x0024_Purch__x0020_Inv__x0020_Line, Column: Item_x0020_Category_x0020_Code, Value: . Errors in the OLAP...

Fine ThkQ !

Left the idea to work on that further :O)

got into another task.

Hi solved ! i used picture tool from tool box to bring in the picture, which i missed previously.

Brian K. McDonald (11/8/2010)

---

Thanks for posting that. Just for clarification though... when you say you changed the IP Address, this section right here has the actual IP address of the...