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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.