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 Chriss Miller 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: *

  • Users: Earth
  • Order by date
  1. Earth

    View all transformations in one window

    Hi Everyone While looking over someone's shoulder at DTS a few months back (SQL Server 2003) I remember seeing a window that showed all data transformations. I can't remember how to get to it (I only know how to look at the individual properties on transforms). I'm using SQL Server 2000. Can...
  2. Earth

    XML not supporting Symbol: Work around

    Jon Thanks for your help. It was my mistake - not saving the XML in unicode. Kind Regards Earth
  3. Earth

    XML not supporting Symbol: Work around

    I have no control over the data, the database, or the xml that is produced. Is there no way to change, for example, <xmlstuff> <Item>MyItemName™ Is Tradmarked</Item> </xmlstuff> Into <xmlstuff> <Item>MyItemName&#8482; Is Tradmarked</Item> </xmlstuff> through XSL/XSLT? Thanks for your...
  4. Earth

    XML not supporting Symbol: Work around

    Hi all I'm new to XML. I'm supporting a website that displays XML pulled out of a database. The problem is that some rows in the database in a particular field that is returned contain the registered trade mark symbol (<Item>NyItemNameTM</Item>). I have pulled sample XML out and changed the...
    • Earth
    • Thread
    • Replies: 4
    • Forum: XML
  5. Earth

    Excel Chart: Adding 2nd Axis turns to Stacked Columns

    Hi I am trying to build a very simple Excel chart, with two data series. I want it to be a simple column chart, but with the series plotted on separate axis. What's happening is: I build the chart as a column graph. I right click Series2 -> Format Data Series -> Axis (tab), and select...
  6. Earth

    DTS: Conditional Load

    Thanks! They both sounded like great suggestions. Quatermass' fit in with my existing structure slightly more, hence I have implemented, and it works great :)
  7. Earth

    DTS: Conditional Load

    I have a SQLServer 2000 table that is only populated with data when an error occurs. The population of this table occurs in a DTS package that is scheduled to run nightly. I am in the process of creating another DTS package that will be run as part of this same job. I want this new DTS package...
  8. Earth

    passing parameters to an executable

    Thanks DrJavaJoe. In the end, I did use Command(), and wrote my own procedure to process the results of this into the variables I wanted various parts of it to sit in.
  9. Earth

    passing parameters to an executable

    Is it possible to pass any parameters to an executable? Thanks in advance.
  10. Earth

    return max across columns

    Hi, I have a table that looks like this: ID Date1 Date2 Date3 Date4 -- ----- ----- ----- ----- 1 1 Jan 2 Jan 3 Jan 4 Jan 2 10 Feb 8 Feb 6 Feb 4 Feb I want to return: Each ID, and the max date across the four date columns. eg. ID DateMax -- ------- 1 4 Jan 2...
  11. Earth

    Dynamic column headings (based on SELECT) in Temp table

    I have adapted the solution at the first link sent. It seems to be a very flexible and good solution! If anyone goes onto use a similar approach, be careful as the solution does not cater for NULLS being returned in the query you specify to create your Column Headings. An easy solution to that...
  12. Earth

    Select query between 2 databases

    Do the two databases reside on the same server?
  13. Earth

    Dynamic column headings (based on SELECT) in Temp table

    Terry, As far as I can tell the solution you suggested doesn't allow me to create a fully dynamic table - where the number of columns (and names of them) are dependent on a previous select statement. I believe I will have to use a cursor to make the table, but then perhaps a solution similar...
  14. Earth

    Dynamic column headings (based on SELECT) in Temp table

    Hi everyone, Overall problem: I currently have a nice sproc that returns the &quot;right&quot; data but in the &quot;wrong&quot; format. For example, Current format - AsAtDate Mnemonic Amount -------- -------- ------ Date1 M1 A1 Date1 M2 A2 Date1 M3 A3 Date2 M1 A4 Date2 M3 A5 Date2...
  15. Earth

    Conditional select - dependent on results returned by other select

    It's working now. This might not be the most efficient way to do it, but it works: CREATE PRODEDURE dbo.myProcedure @dateFrom datetime, @dateTo datetime AS CREATE TABLE #myTempTable DECLARE @todayCount int DECLARE @currentDate datetime SET @currentDate = getdate() If (left(@dateFrom,11) !=...
  16. Earth

    Conditional select - dependent on results returned by other select

    Hi dbtech, I'm not sure that what you suggested would work in the way I need. As If1 will more than likely return a RANGE of dates, not just a single date, doing I believe that @@ROWCOUNT = 0 as a conditional test would not achieve my purpose. However, if I could put in a SELECT statement...
  17. Earth

    Conditional select - dependent on results returned by other select

    I have an existing (working) stored procedure that I need to modify. The basics of the SP are: CREATE PRODEDURE dbo.myProcedure @dateFrom datetime, @dateTo datetime CREATE TABLE #myTempTable DECLARE @currentDate datetime SET @currentDate = getdate() If (left(@dateFrom,11) !=...
  18. Earth

    duplicate rows in table

    select [date], count(*) as myCount from [call info] group by [date] having (count(*)>1) Has worked for me before..... but maybe not?
  19. Earth

    dump data to excel from SQLServer: XML, BCP, DTS?

    Hello, I'm trying to determine the best solution for a problem. My SQLServer db has a jsp/java front end - intranet based. I want to give my users the ability to dump data into excel with the press of a button on the interface. I have a stored procedure written that returns the correct data (as...
  20. Earth

    UNION results of local query with SP on another server

    Thanks dbtech. I have actually tried what you mentioned. I have discovered that there appears to be a limitation in SQLServer that prevents you from executing a SP on Server2 from Server1, and putting the results into a temporary table (on Server1, obviously). You cannot execute the a SP on...

Part and Inventory Search

Back
Top