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

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

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

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

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

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

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

I'm looking for an elegant solution for this problem: I have two servers, Server1 and Server2. I am attempting to write a stored procedure on Server1. Within this stored procedure, I want to UNION the results of a SELECT statement with a recordset that I can get by running a stored procedure on...

This is the format of the query that I am trying to run: SELECT * FROM (SELECT Date, Thing='Thing' FROM tblBalancesAsAt WHERE Date='4 June 2002' UNION SELECT Date, Thing='Thing' FROM tblBalancesAsAt WHERE Date='6 May 2002') The error that I'm getting is: &quot;Incorrect syntax near ')'.&quot...

Hi, I believe that a query such as: SELECT AsAtDate, BankMnemonic='ALL', StartOfDay etc etc Will return the relevant rows with a column named &quot;BankMnemonic&quot; filled with the constant 'ALL' for each row (as well as the other normal columns). I'm attempting to build my SQL statement on...

Hi, Why does SQL-Server have a requirement (limitation?) that a subquery that has an 'order by' clause must also use TOP? I must be missing something. Thanks.

I am able to run a query that returns n rows, within a specified date range (one row for each date). I want to be able to recall this same query and get either the &quot;next&quot; n rows within that same specified date range, or the &quot;previous&quot; n rows. The rows need to be presented...

Hi again, I have a datetime column which I multiply by another column (ints). I then want to sum this result. However, Access will not allow me to perform this sum, with the following error msg: &quot;The sum or average aggregate operation cannot take a datetime data type as an argument.&quot...

Hi everyone, I have a query that has a subquery. The subquery is only returning two columns: one is a calculated column, and the other is the original column. I have given the calculated column an Alias. Quick question: Can I refer to this calculated column by alias name in the outer query...

Hi, Column B contains a date. Column C contains a time. I want to concatenate these two into one &quot;Datetime&quot; column. Any ideas? Formula? VBA? Thanks heaps...

Hi all, I have an Access97 DB. It's made up of many tables etc, which are becoming slow on loading due to the number of entries stored in each of them. It's therefore time to do a dump. I simply want to end up with a replica of the back end that only contains certain tuples from certain tables...

Hi All, I have a fairly large Access97 db which I need to convert to Access2000 ASAP. It has separate back and front ends, and lots of screens and code running to keep them operating. I would like some general guidelines for how i should proceed. What should my actions be, and what problems...

Hi, For my thesis I'm aiming to develop new/extend existing interface design principles for ecommerce. I'm in my early stages, and am simply reading around the topic. Does anyone have any suggestions of * websites * books * conference papers or * journal articles that I could read on the...