Search results for query: *

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

Thats the same as I did. Except, the first report already exists and has nice database table names and field names. When I create a report based upon the same database, all the database tables available have names along the lines of no_src1 - that sort of thing. I think in creation of this...

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

I think this is where a datamart is just a copy of an operational db with no denormalisation etc. The idea is that it may do the job to start with but soon becomes inflexible when you want to report on information that is not stored in the original db.

Hmm, well I'm still not 100% on what you're doing but I guess you are creating an object. So in your select clause you've got 'mydate' and in your where clause you should have something along the lines of @Prompt('Enter date',date,Mydateclass.mydate,multi,free) Is this what you are doing? Nick

I don't understand why you need to convert the date?&nbsp;&nbsp;Are you trying to do something with the list of dates that is returned?&nbsp;&nbsp;I would use a condition along the lines of:<br><br>Mydate Less Than Prompt('Enter a date value')<br><br>Do you need something more?&nbsp;&nbsp;There...