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

...and dbs. Hence, the approach (in my sproc) I am trying to get work atm (which won't be the most efficient, but is a nice starting place) is: **** CREATE PROCEDURE dbo.spByTypeTesting AS DECLARE @sql varchar(1500) CREATE TABLE #tblData (AsAtDate datetime, Mnemonic varchar(4), Amount...

...#myTempTable DECLARE @todayCount int DECLARE @currentDate datetime SET @currentDate = getdate() If (left(@dateFrom,11) != left(@currentDate,11)) /* If1: dateFrom is not the current date */ BEGIN Insert into #myTempTable SELECT statment from local db1 END If (left(@dateTo,11) =...

...I believe that @@ROWCOUNT = 0 as a conditional test would not achieve my purpose. However, if I could put in a SELECT statement such as: SELECT * FROM #myTempTable WHERE CONVERT(datetime,convert(char(12),Date)) = CONVERT(datetime,convert(char(12),@currentDate)) And then do the...

...datetime CREATE TABLE #myTempTable DECLARE @currentDate datetime SET @currentDate = getdate() If (left(@dateFrom,11) != left(@currentDate,11)) /* If1: dateFrom is not the current date */ BEGIN Insert into #myTempTable SELECT statment from local db1 END If (left(@dateTo,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...

...on Server2 that: a. Creates a table on Server2 b. Fills that table with the relevant data 2. Runs the: SELECT Whatever FROM tbl UNION ALL SELECT * FROM Server2.tbl On Server2.... Obviously I could just SELECT/UNION query directly on tables on Server2 - but the necessary query is extremelly...