Search results for query: *

When I export to Excel 2008 from SSRS 2005 the background color LightSteelBlue is lost and shows up grey. This is not the only color that does this. Many others show up grey as well. I've even tried putting in #B0C4DE (LightSteelBlue) for the color. The color always shows up correctly in...

Anyone know if it's possible to to an advanced filter on a dimension according to the 2nd or 3rd digit of the label? For example, on the following label (601NNZ) I want to filter out anything with the 3rd from left digit containing a 1 Any suggestions?

Does anyone know how to display a hyperlink with an expression. I am trying to display a hyperlink in the detail section of a report. Each line of my report is different so I need a different hyperlink for each row of data. I've been trying to do something like this in the expression builder...

I am having a problem with inserting data into a table from an OLE DB connection. Something funky is going on behind the scenes with the OLE DB engine and what it sees in the field. I know the data type for my column s/b numeric(12,2) yet the error keeps coming back: Cannot get the current...

Is this possible? I have an index on the table, but it's not the way I would typically want to view the table if I SELECT * I just want the table to be consistent for generic viewing purposes. Any ideas would be appreciated. Thank you.

Three times a day I need to drop a table (say, TABLE1) and rename another freshly imported, prepped and indexed table (say, TABLE1_TEMP). They are the exact same table, one just has more current MTD info. I keep getting locked out from dropping TABLE1 as people are running selects and views...

Please help! I need to replace a table with another. Both contain the same columns, one has more current MTD data. Because I need 100% uptime I can not insert b/c it's takes so long, it's 10,000,000 rows :( TABLE1 - feeds an Inventory View right now. I need to replace it completely with the...

I have two tables (historical and live). I need to combine them and and use max(period) to keep only the most recent period the tag existed. SQl Server keeps telling me I have incorrect syntax by GROUP. Am I doing something wrong? Can I even do a union subquery in the FROM clause? Please...

Has anyone experienced problems with left joins when working with a linked ODBC flat-file? I am getting all columns from table a.inventory However, info from table b.inventory_group_desc is coming back null when I do a left join. I've tested the crap out of it. It works in Access when i...

I'm trying to set up a data warehouse in SQL Server 2005. There's various methods, here's mine. I'd like to have a database for every month. Within each database I will have the same tables. MY QUESTION: I'd like to create a seperate Execute SQL task that creates 1. the Databases and 2...

I'm an Accounting Manager at a large steel company. I need the most versatile rounding function I can get. I found this function and added the "nearest" function so it can now round any way you could possibly want...UP..DOWN..NEAREST. It mimicks MS Excel rounding so you'll never have to...

PHV's SQL for ranking inside a query is VERY USEFUL. The use of subqueries is perfect for solving this dilema.... Now I want to take it further...I need to rank according to: 1. PRODUCT_NUM (ASC) Within the Product_Group_Name I need to rank according to: 2. INVOICE_DT...

I found a module that allows you to center columns "inside" a list box. Previously I read a few threads on here that said this was not possible. Thought I would post it here for your reference. In the Row Source property of the List box type: SELECT DISTINCTROW JustifyString("Form","List...