If I had to pick a Plan B, I'd probably pull the file into TextPad and use regular expressions to transform it into something more SQL-friendly.  You could get it...

Looks like something I would tackle with SSIS.

You could use a conditional split transform to explicitly filter out the non-data rows, or just set up the error action on a...

If you run a query that uses a linked server, the data moves directly from the linked server to the server running the query.  If you use SSIS, the data...

Dynamic SQL is illegal inside a function. 

Functions cannot modify data, so INSERT, UPDATE, and DELETE are illegal (except on local TABLE variables).  EXEC (@string) is also illegal because otherwise...

If there is no requirement that the report server and offsite server be in sync, you would cause less load on the network if you staggered the schedules.

You could also try replication.  You can replicate a subset of the tables in a database, even a subset of the columns in the chosen tables.  It works very well,...

It may depend on what you mean by "work on a SQL 2005 Server".  If you mean the program will run on the same client it is now but the...

In T-SQL you need to use nested REPLACE funtions:

select

replace(replace(replace(

    vdl,'Lead Free ',''

I copied the code from SQL 2005 Management Studio.  You have to fix all the double-spaced lines, restore the indenting, change the font back to a non-proportional font, etc.  But...

BOL for SQL 2005 says:

"Returns the number of date and time boundaries crossed between two specified dates."

I took them at their word.  Silly me.  Although a careful reading of...

The most obvious solution is building the dynamic SQL piece by piece:

declare @cmd varchar(8000)

set @cmd=

datediff

(yy,DOB,getdate())

Here's three more variations:

select

convert(varchar, cast(cast(col_yr_no as

You're pretty short on details about exactly what you want to accompllish, but this query might be a useful starting point.  This would calculate the Available amount...

I've been working with computers for over 30 years now.  My biggest gripe is that I can't stand 60hz CRT refresh.  I don't put up with it at all on...