I don't know how are you using the parameter but this sholud helpyou going Declare @str varchar(200) SET @str = DB_NAME()--Assuming is going to be runned from other databases only --otherwise use dbname as a parameter +'.dbo.sp_helprolemember ' + '''' + 'RoleName' + '''' --print @str exec (@str) I don't know why can't the "plus" […]
2003-11-13
2003-11-12
2 reads
That may be a security issue, check if you are in the group OLAP Administrators and you have full access to the directory where the repository is (C:\Program Files\Microsoft Analysis Services\Bin\msmdrep.mdb). It may help too if you convert the repository to SQL. To do this, go to Analysis Manager, right-click on the server, then choose […]
2003-09-03
Thanks for the tip of using Tab delimted, renamed to XLS. It works great! Using xp_sendmail, do any of you know a way to change the default attached message from .txt to .XLS?
2003-08-28
I too have the same issue, and have not been able to find an easy way to do it, short of changing the queries to SQL format in the design of queries and checking to see if they run in query analyzer then deciding how to best recode or execute them in SQL server. I […]
2003-08-19
What is the type of the variables? If you're using integers, your division is an integer division, truncating the fractional part. Check the division operator in BOL for more info.
2003-08-15
Thanks to a friend of mine: Declare @lastSunday datetime Declare @cDate datetime Set @cDate = GETDATE() Set @lastSunday = dateadd(d,-6,dateadd(d,(7 - datepart(dw,@cDate)),@cDate)) PRINT @lastSunday
2003-08-14
1 reads
2003-07-30
The error ocurrs the moment I attempt to select a source from the drop down list. Rusty
2003-07-29
Not exactly using CASE, but this should do the trick : SELECT * FROM MyTable WHERE IsNull(FirstName, <Name to look for>) = <Name to look for> AND IsNull(LastName, <Name to look for>) = <Name to look for>
2003-07-28
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers