Recent content by nickdaniels

Well, I tried that, but with a select statement like this: SELECT convert(smalldatetime,(convert(varchar(10),qrepository.dbo.contact.createtime,103))) FROM qrepository.dbo.contact I got the same error. Typical values in this column are 1/11/2001 09:57:23 29/10/2001 10:57:55 Any ideas...

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...

What version of BOb are you using, what database is your repository on, what spec PC / server are you using. I have seen the above on version 3 of BOb with low spec PCs. Are you copying and pasting cells with hundreds of thousands or rows of data in? It is certainly not normal. Nick...

In the end I added the established date from account to the select and within the report (business objects) compare the two dates and where they match just display those rows. It runs like a dog, but hey! its a start. thanks anyway Nick ndaniels@ventura-uk.com If it's Data Warehousing or...

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...

BO is absolutely suited to this. Version four has a scheduling tool called document agent server, version five a much improved tool called Broadcast agent server. Generating the sort of files you require is built into the software. One caveat would be that the look of the HTML files can be...

That doesn't happen when I do it. What you could do is drag the condition into the table, rather than having it in Global. (Format/Filters...) <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...

In fact the limits are 65,536 rows by 256 columns - it all depends on the volume and depth of information you are dealing with <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...

Doesn't Excel have a limitation on the number of rows it can cope with. I know it used to be 16,000 ish and now its maybe 64,000 ish? <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 -...

select table_name from all_tables for oracle <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!

I assume it has been done for security purposes so if an individual looks behind the scenes, all they see is meaningfully named tables with meaningfully named columns, and only those columns that are used.

To take this a stage further, would it be possible in this aliased table to only make certain columns available/visible. Would it be possible to give the visible columns meaningful names?

Right, I understand how this has been setup. So now my problem with that on the Database menu I do not have the Set Alias option. In fact, I only have a couple of available options and about 15 greyed out. Available are Verify database and logon server, logoff server. I'll look into getting...