Search results for query: *

I have the following piece of SQL which takes a datetime database column containing values like 13/11/2001 07:25:23 and attempts to convert it into a date 13/11/2001. SELECT convert(smalldatetime,(convert(varchar,qrepository.dbo.contact.createtime,103))) FROM qrepository.dbo.contact I get...

Apologies for a newbie question: When I open a Powerplay report, I am prompted for a choice of which cube I wish to open it with. Is there a way to automatically associate a Powerplay report with the correct cube? cheers, Nick Nick ndaniels@ventura-uk.com If it's Data Warehousing or...

I have an SQL statement: SELECT contact_lookup.summary, count(DISTINCT contact.vduid) FROM contact, contact_lookup WHERE (contact_lookup.contact_key=contact.vduid) GROUP BY contact_lookup.summary This generates the following message: [Microsoft][ODBC SQL Server Driver][SQL...

I need a query which will retrieve the oldest account number for each store, showing the account number, the date the account was established and the store code. The code below is close, but brings back every account number for each store and assigns it the same (oldest) established date. Does...

Apologies for the simple nature of this question, but I had never used Crystal until today: I have a report with an item called 'Connects'. I want to trace the definition of this back to the database table and field(s) it is derived from. If I click on the item on the report, I can see that...

Can anyone recommend a company in the UK who do training in SQL Server 7?<br><br>Thanks, Nick <p> Nick<br><a href=mailto:ndaniels@ventura-uk.com>ndaniels@ventura-uk.com</a><br><a href= > </a><br>If it's Data Warehousing or related then I want to know - but post it to the forum!

An existing report provides information relating to<br>failed loan applications.&nbsp;&nbsp;A simple 'yesterday' pre-defined condition is<br>used based upon trunc(sysdate-1) for the loanapplicationinvalid.dateloaded.<br><br>It is becoming apparent that this condition excludes cases where any of...

I'm interested in your experience of using BOb with an OLAP package, via one of the OLAP Access Packs.&nbsp;&nbsp;In particular, how much new stuff will a a user have to learn.&nbsp;&nbsp;On the one hand I have seen that you select and OLAP data source at the same point where you might select a...

I've been doing a bit of background reading and was suprised to see that some OLAP products allow you to write to the database as well as read from.&nbsp;&nbsp;Is this purely for setting up summary information?&nbsp;&nbsp;I have a data warehouse background where, certainly in terms of the...

I have a problem using&nbsp;&nbsp;v5.0.2 / WEBI 2.5 where I prompt a user to select a number of dates from a pull down list.<br><br>I create a condition on the fly by pulling in my date object such that I get a condition like<br><br>date_object inlist 'Select one or more dates'<br><br>This works...

I am having a problem generating accurate sql in the following situation.&nbsp;&nbsp;We have accounts which may be have one of a number of statii.&nbsp;&nbsp;An account may be rejected, in which case a single record with a statuscode of 'R' will be held in the table.<br><br>An account may be...

We're currently moving from 7.3 to 8.0.&nbsp;&nbsp;I've heard a little about the use of materialised views in 8i and would like to know of any practical experience anyone may have of their useage.&nbsp;&nbsp;This is coming from a data warehousing point of view but any information would be...