Thank you for the response, I using iif([DialerType].CurrentMember IS [DialerType].[Dialer Type Code].&[2180], some value, other value)Works also, and your's also works, but the way I am new to MDX, do you know something on MDX like T-SQL does case statement, I can have at least three values to evaluate, the IIF only works for two sets […]
2004-02-11
quote: It is not connection string in sp_who or sp_who2. The application has to be designed to use the workstation ID in the connection string. well, yes, I was thinking the other way round Cheers, Frank
2003-08-12
1 reads
@Antares686: thanks for your reply, it would have been nice, but I can live without it
2003-08-01
1 reads
Hi ilan, quote: NO i test the tow possibility and still a gen an error --------------- when i do this set @recipient='select @pstrNames' OR this select @recipient='select @pstrNames' i get this Server: Msg 137, Level 15, State 2, Line 1 Must declare the variable '@pstrNames'. ----------------------------------- is this the full statement you've posted or is […]
2003-07-25
2 reads
Personally I would consider doing like so. Replace all occurrances of @DateHolder with DATEADD(ss,-1,DATEADD(d,DATEDIFF(d,0,GETDATE()+1),0)) in your query code and get rid of the variable declaration. Replace @tdate with GETDATE() and get rid of variable declaration. Not really sure you need SET DATEFORMAT so say good-bye to it. Then try this. CREATE PROCEDURE GetFrontDeskData;1 @PracticeID bigint, […]
2003-06-17
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