Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nickdaniels

    [Microsoft][ODBC SQL Server Driver]Error in row0

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

    [Microsoft][ODBC SQL Server Driver]Error in row0

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

    Choosing correct Cube

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

    Unable to Group By text, ntext and image

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

    Business Objects performance

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

    oldest account by store

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

    oldest account by store

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

    BO Scheduling

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

    Global filters affecting reports after "duplicate report" is selected

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

    To &quot;Excel&quot; or not to &quot;Excel&quot;?

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

    To &quot;Excel&quot; or not to &quot;Excel&quot;?

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

    list all Tables

    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!
  13. nickdaniels

    How to identify underlying table and column names

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

    How to identify underlying table and column names

    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?
  15. nickdaniels

    How to identify underlying table and column 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...
  16. nickdaniels

    How to identify underlying table and column names

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

    How to identify underlying table and column names

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

    What is a STOVEPIPE Datamart???

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

    Accepting a date from the user

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

    Accepting a date from the user

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

Part and Inventory Search

Back
Top