Search results for query: *

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

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

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

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

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

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

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

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.

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

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

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

Do the two databases reside on the same server?

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

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

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) !=...

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

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) !=...

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

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

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