Search results for query: *

nope, lbass.. I dont have such option. In the earlier versions its not possible?

Anyone know how can I put repeating text for the rows' headers? Here is what I want to get from it but I cannot figure out how to put the text fields to appear on each row 01/01/2007 ---------------------------------------------------------- [Product] -...

and despite, i will give it a try as you suggest, George. I willonly write the results in a table to be able to see it after I run the procedure from the DTS

guys! it is something with the parameters! I put them as fixed values and it ran fast from the API! ...but of course this does not mean I have fixed it...

George, the problem about this query is that it runs fine :))) but only from QA. I would prefer it performing equally slow from both places but now I am in big confusion - when I run it from QA it executes in seconds returning the wanted resultset, but when it is put for example even in a DTS it...

George, I tryed this already but no success... I rewrited the proc to look like this: CREATE procedure dbo.crs_monitoring7 @BU as varchar(3), -- ICE. ; FRF. ; FRP. @DateFrom1 as varchar(10), @DateTo1 as varchar(10), @net as int, -- 0.Whole Country; 1.Own Network 2.Big Representatives...

you think it might be the user, vbkris? i will give it a try with sa to see what happens.... I found sth more in the meantime - when I put the stored proc to execute in DTS, again it is terribly slow!??? I will let you know what happens with the same user

Yes, profiler, but I also watched the time for the creation of each of the temp tables that I have inside the stored proc - if I run through QA it takes seconds to create each, started from the api-s it takes minutes! Different query - yes, works OK. The applications that show the results of...

hi Guys, I have a query which runs for 20 sec in Query Analyzer but from API it takes more than 5 minutes. I would say it was in the application but I monitored it and I see it is neither the application code nor the connection time which slows it down - it just runs so slow when started from...

Jocasio, can you publish a link yto the tutorial, please? Mira

all day I couldnt find a thing that helps this terrible grouping problem. Jocasio mentioned something about the SHAPE statement which actually gives a hope ... but I am not sure how to use it nor that it's extly that thing. Here is what the problem is exatly: when I add the grouping level to...

Flex13, yes copying cubes offhours would be a solution but - the process is organized in a way that the cubes are created and copyed mornings (that's when we get data from branches). I am afraid someone may be using them during the copying.... At the same to forbid access to the machine...

Is there a thing I can use in a batch file to stop net users from opening the cube while it is being created or replaced? -something like net stop maybe....what do you guys use?