Programming SQL

OPENROWSET not working on one cluster node
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=Z:\FILE\FILE.XLS;HDR=YES', 'SELECT * FROM [Country$]') select registrantid, firstname, lastname, title, company,address, address2,city, statecode,countryna... 18 Jul 2008 11:20

sql server express
Hi, I need to figure out a way to schedule a .bak file transfer from a remote computer to our server. I know that SQL server 2005 express edition does not have a job scheduler of any sort so I will have to use a third party tool for a scheduled SQL backup. Is there any way to automate a file transfer after t... 10 Jul 2008 13:25

Index a calculated column in SQL Server 2000?
Hi thanks for looking. I'm trying to create an index on a calculated column in SQL Server 2000 using: ALTER TABLE Trade ADD TradeDateTrimmed as DATEADD(dd, DATEDIFF(dd, 0, TradeDate), 0) GO CREATE INDEX TradeDateTrm ON Trade(TradeDateTrimmed) GO The column is created correctly, yet when I create the index ... 11 Jul 2008 17:10

problem solved
Hi, yes i have sql server 2005. here is my procedure which solve the problem. WITH tmpTable AS ( SELECT [ResultTable].* ,ROW_NUMBER() OVER(ORDER BY Zeitstempel DESC) AS 'RowID' FROM [ResultTable] ) SELECT * FROM tmpTable WHERE RowID = @Position greeting martin "Martin Priebe" <mar... 10 Jul 2008 08:15

Help With Full Text Search. Performing AND across columns
I am trying to perform the following query on a table that has been indexed using Full Text Search. The table contains multiple columns than have been indexed. (Below, all xml columns are indexed). dbo.maintable(ProfileID int pk) dbo.fts_table(ProfileID int pk fk, col1 xml, col2 xml, col3 xml) I want to perfo... 10 Jul 2008 07:14

Oracle cron job calling SSIS package
Hello, Can a Oracle cron job call a SQLServer SSIS package? Has anyone tried this? Thanks, SQL_Help ... 23 Jul 2008 09:11

Top X Results - get row x
Hi, I have a problem qith a stored procedure. I try to get the top 10 results of a table. Select Top(10) * from [Results] order by Zeitstempel DESC Now i want to create a procedure which get the Position X of this result. For example the third row of the top ten results. But i don�t want to use a ... 10 Jul 2008 07:14

SQL 2005 Jobs
I want to explore the properties of an existing job by going to Management Sutdo ->SQL Server Agent -> Jobs Right click one of the jobs and select 'Properties' However, it did not show up the properties but 'New Job'. Any idea why? ... 15 Jul 2008 04:06

Desparate Appeal: Why is this Query so Slow?
This is related to the problem I posted earlier, and might actually be the route cause. I have two tables, like this: CREATE TABLE Events ( [EventID] [bigint] IDENTITY(1,1) NOT NULL, [EventTime] [datetime] NOT NULL, [Description] [varchar](50) NOT NULL, CONSTRAINT [PK_Events] PRIMARY KEY CLUSTERED ( [Even... 11 Jul 2008 14:04

Script to order tables in there foreign key reference
Hi, I want to retirve list of all tables from a database in order to there foreign key reference from another tables. ie. if A is the parent of B and C. And B is the parent of D, E, F. then order of the tables are : TablesNames F E D B C A Any idea. Rahul ... 10 Jul 2008 07:14