Search results for query: *

I don't know if anyone has ever encountered this strange behaviour, it certainly sounds like like nonsense so am I missing something? Here's the facts: I am writing a query in ssms, reasonably complicated, with temp tables, linked servers and lots of lookup/transformation steps. When testing, I...

I've got a mdx query that when run, is returning the all members of each hierarchy level. how can I filter the "All" members out? p.s. The code is adapted from auto generated code, so any pointers for making it better would be appreciated as well SELECT { [Measures].[Actual Sales] ...

I have a standard mdx query, along the lines of: select crossjoin ( Product.[Hierarchy] , Measures.[Measure] ) on rows , Location.Hierarchy on columns from cube however, I'm trying to use this as the source of a SSRS report and SSRS is trying to hard code all the...

Hi Everyone. I'm using asp.net 2.0, .net framework 3.5... I've got a gridview control with normal command buttons and I've used GetPostBackEventReference to add an event against an entire row, where when enter is pressed against the row during edit, it automatically saves. However, the...

A newbie to asp.net so go easy please... Basically, I've got a gridview with update and insert. What I want to do is, when column1 is changed, before the save happens, check if the new value already exists somewhere else in column1 and if so, prompt the user to either overwrite or discard the...

Hi Everyone, I've got a site with an images directory and a secure directory. The site contents are in the secure directory, with a login page and a banner page in the root. The banner page is reused on the secure pages as well. The problem I'm having is, on the banner page, I use background...

Strange problem... I've got this one server where ansi dateformat strings are being switched around, as in the subject. I've not seen this anywhere else, just this single server... Obviously I can correct this with a bit of programming, but I'd rather fix it at the server level. Any ideas...

I've got a strange problem with on of my test servers. On my development server, a report which contains 7 subreports works fine, however when I deploy it onto my test server the sub reports doesn't appear on the main report. If I open the sub reports individually, then they all work fine...

I've got one sproc which returns multiple resultsets. Is it possible to access these multiple results sets from a report? when I create a dataset based on the sproc, only the first resultset is returned. Thanks -------------------- Procrastinate Now!

Hi Everyone, is there a way to turn the macro security to low for all office applications and all users on a machine in office 2003? I vaguely remember a registry key somewhere... Thanks -------------------- Procrastinate Now!

Hi Everyone, I've got a batch file which is being executed by a SQL Server Job. However the batch file generates some files and other stuff so it means it needs to be executed in the same folder. Trouble is, the SQL Server Agent executes the batch file in the windows\system32 folder. Is...

basically, I have a table with a non-clustered varchar primary key. I'm wondering if I need to add another explicit index onto the primary key index, or if the primary key itself is by default indexed. thanks. -------------------- Procrastinate Now!

Hi Everyone. I've got a little sproc which is used to send query results to various people. However I'm having trouble getting it to format nicely, so have set the output to be an attached file, with an xls extention, using tab spacing. This *almost* works, the only problem is that below the...

Sql server 2005. I did a big delete on a database a couple of days ago, and the size of the database didn't really go down much, nor did the size of the full backup of the database. I was planning to manually run a shrink today and a index rebuild, however I notice that today all the space...

Hi Everyone I've got a extremely long running delete process that's going to be run on a live system, this process isn't top priority so I was wondering if it's possible to lower the priority of this process, in the same way you can with windows processes. Does sql server 2005 support this...

Hi Everyone. Just wondering if anyone has any general strategies to deploy cubes from the development environment to a production environment or to a remote server. Basically, the simplest approaches, things to watch out for and general tips. Thanks -------------------- Procrastinate Now!

Hi Everyone... I've taken over a db schema which is to be used across multiple seperate locations, each with it's own set of isolated tills/operators/transactions... The problem is, because of the isolated nature of the database, the transaction tables use a composite primary key consisting of...

Hi Everybody. I'm totally new to Visual Studios (2005) but have been given some development to do with it so please forgive me if my questions seem very trivial. Currently I have a solution which contains 3 projects, I have been told to modify 1 of the 3 projects to include some error logging...

Hi everyone... I've got some code to output the results from a stored procedure to a excel file, everything works fine. however I've recently noticed that the results exported are being cut off. I've checked that the correct number of results are being returned, and recieved at the front end...

xp pro sp2 everything working fine, then this morning, when turning it on, gets to the windows splash screen, then blank screen and nothing else. No error messages, no crashes, just stays at the blank screen for ever. tried last good configuration, same thing... tried to use safe mode, after...