Recent content by buddafish

Hello - We are in the middle of implementing E9 and I have begun working with the Service Connect Tool. We have several training databases (Train1, Train2, ect.) for specific reasons. When I create a workflow process, it appears to be updating the Train1 database. Can anyone offer some...

Paul - thanks for taking a look. Here is the MDX for my YTD-Pounds measure: Sum(YTD([Time].[Year Quarter Month].CurrentMember),[Measures].[Pounds]) scottie

Hello All - I have an issue with a YTD measure. Being pretty new to MDX I found several examples and they all look pretty much the same. Here is my code: Sum(YTD([Time].[Year Quarter Month].CurrentMember),[Measures].[Pounds]) When analyzing YTD-Pounds by ProductType July-07 & July-08 in...

doh! thanks again!

well, that appears like the perfect answer, yet for me, i return null for the object_name. select * from sys.procedures shows the sproc by name and object_id, but the object_id <> @@procid. ?? thanks for the reply. i will keep kicking it around.

All - I would like to be able to determine the stored procedure name from within the procedure itself. Kind of like what I do with the database name: SELECT @DB_NAME = db_name() Anybody know a way to get the procedure name? Ideas? Thanks in advance - Scottie

Actually there could be anywhere between 1 and 4... still working out some ideas

Excellent! Thanks for the help. I knew this could be done but was WAY off on my approach. thanks again !

Hello all, I am attempting to return a row as such: [Order Number, Salesman1, Salesman2] from a table that has 2 columns: Order Number, SalesMan. Data: OrderNum SalesMan 1234 Bob 1234 Mike Both Salesmen share the order and i would like to output on one line...

Hello All - I have a working linked server SQL2005 <--> Informix 10.0 and can use an OpenQuery statement to retrieve data. What I would prefer to do is a "Select * from ServerName.Database.Owner.Table" but this keeps throwing errors. I know almost nothing about Informix and am assuming that...

Perfect!! ADO is the answer. Thanks for the reference chart too! (I missed the footnote) Scott

Perfect!! ADO is the answer. Thanks for pointing me in the right direction. Scott

Hello All - I am coding a utility to write stored procedures based on the field names and data types in any given table. I can get the field-Type and field-Size but if the Type is a Decimal (number), I am hitting a wall when attemping to find out the precision and scale via code. I can only...

Hello All - I am running into a brick wall with a simple SQL Task attempting to return (output) the value from a stored procedure into a global variable. I have tried both OLE DB and ADO.NET connection types and have Googled for hours (finding a lot of complaints) but no solution thus far...

Hey Keithmyers, did you figure this out? We are experienceing the exact same problem. TweakMYbox - can you elaborate on which directories in Exchange that should be excluded? Thanks! - Scott