Search results for query: *

I have a normalized table as follows: Store Userid 3 bob 3 jim 3 joe 4 bob 4 sally and would like to build a view on top that transforms the data to: store userstring 3 bob,jim,joe 4 bob,sally We're also using IBM UDB 8.2. Does anyone have any ideas? thanks

We've recently created a dashboard and we would like to be able to print selective pages. Has anyone been able to print what is on the screen in a nice format?

We've recently created a dashboard and we would like to be able to print selective pages. Has anyone been able to print what is on the screen in a nice format?

We've recently purchased BOXI Dashboard/Performance management and I am looking for online resources such as best practices, standards. Does anyone have any recommendations of online sites/white papers/documents that are available. thanks

I'm trying to write a formula whereby I can substitute the contents of an IN statement. Let me illustrate: This works: Store_id in [1, 2, 3] But, would like the 1, 2, 3 to be replaced with a variable along these lines: global stringvar test; test := '1, 2, 3'; store_id in [test]; Does...

Here's a snippet from the code: SELECT A.REG_PRICE FROM PRICE_TABLE A WHERE ITEM_ID = 40 and STORE_ID = 992 and EFFECTIVE_DT = (SELECT MAX(EFFECTIVE_DT) FROM PRICE_TABLE B WHERE B.ITEM_ID = A.ITEM_ID AND...

Hi, we've have a very/very large table indexed by STORE, ITEM, DATE and would like to reference the row with the last date less than or equal to an input date. We currently have a subselect to find the max(date) but the query is very slow due to the large number of rows being matched. Does...

Has anyone been able to link to an Analysis Services cube using Access?

We've developed an Excel worksheet containing a number of Macros. For some reason when we try running the macros through the spreadsheet, the macros don't fire. (it's almost as if they've gone into a paused state). any help would be greatly appreciated.

Hi, does anyone know how to disable all excel shortcut keys witthout having to individually turn each one off? thanks