Search results for query: *

Hi, This sounds like a strange question, but is there any function (or any other way) of passing a string in and getting out the field with the same name in a query? Something like this (SalesTotals is a column in tblSalesTotal) : SELECT someFunction ('SalesTotals') from...

In the case of the top line : Year Clients Average Average Opened per Day per Month 2003 3989 10 332 If you do "select 3989/365" is rounds it to 10... but : "select 3989/10.00" shows the correct figure of 10.928767 (i.e. almost 11) R

Hi, I'm not sure about the weekends or holidays, I'd just call the 365 days, 365-10-(52*2)=251 days. Have you thought about integer divisions? "select 10/365" = 0 whereas : "select 10/365.00" = .027397 By using 365.00 instead of 365, you'll force SQL to take into account fractions. Rob

Hi All... I'm trying to calculate a dynamic period by using a value from a table to determine the period used. i.e. in some cases I'd like to compare the dates in days and other cases in years, months etc... DECLARE @DatePart varchar(50) SELECT @DatePart = [DatePart] FROM tblDateParts SELECT...

Sorry for the strange title, but I don't know how else to describe what I'm trying to achieve. Imagine a table tblTable (all three columns are integers) : ID Int1 Int2 1 10101 100 1 10102 25 1 10102 50 2 10013 65 I want a simpler way of finding the maximum...

Thanks for the replies. I was thinking something for derived tables like this : select * from tbl1 with(nolock) But then the BO universe query would be something like : SELECT * FROM (SELECT * FROM tbl1 with(nolock)) X Once you do that with a hundred derived tables joined together it...

Yes I do want dirty reads. It results in a marked improvement in processing (report) times. We have a live replication feed of data from the user production server - and i don't want the reporting/universe queries to lock this out. Thanks for your help so far! Bob

Thanks for the tip - but it would appear only Oracle table hints are available there... not for SQL Server?! Bob

Sorry sv... I was under the impression this was for Enterprise.

Hi, We are looking at making a basic BO universe to test it's performance and usefulness against our currect solution (SQL Server stored procedures). We are keeping the SQL Server - and currently the SPs references tables and includes the "with(nolock)" hint. Is there a way to force queries...

Hi, We are looking at making a basic BO universe to test it's performance and usefulness against our currect solution (SQL Server stored procedures). We are keeping the SQL Server - and currently the SPs references tables and includes the "with(nolock)" hint. Is there a way to force queries...

Yes - I have exactly the same problem in the same environment(s) (BOXIR2, SQL Server 2000, Windows Server 2000). I'm using BOXIR2 with a Business View, which has a list of values from it. When I try to save the LOV - I get exactly the same two error messages. Really grateful if anyone knows...

Hi, I have a copy of Business Objects Enterprise XI Release 2. In the Infoview the button at the top called 'My InfoView' is greyed out (inaccessible). When I go into preferences - the option to set My Infoview as the initial view is also greyed out. Why might this be? I need to give my...

Interesting one.... have you tried changing the text in the subreport to a different font/size? Is the font used in the designer in the font list on the ActiveX viewer PC? Bob

C'mon guys.... My question is "why it takes longer in a stored procedure than in QA"... Thanks! Bob

Yes - a second or third run of the procedure makes little difference. Sorry! I know you're trying! Bob

George, Using a temporary table or a "real" one makes little difference to the processing times I'm getting. Bob

Hi Denis, Thanks for the fast reply. But the table tblPPP contains many surnames of 'smith' and therefore the table yyy is populated with a couple of thousand rows. This surely only updates one row? And doesn't explain why this is many times slower as a stored procedure than executing each...

Add an autoincrement field to the table (call it ID or something). Then : SELECT TOP 1 * FROM Table order by ID desc Bob

'tbl' is the table name of the dataset you supplied.