Another point to note is that you can stop this type of query at any point with out losing work already done. So if youe query locks up tables...

I would suggest a recursive Function or Stored Procedure i.e. The Function calls itself to build a string of previous values.

I suspect you have a issue with quoted identifiers in the last two statements. You may want to set quoted_identifiers off so double quotes(") are not seen as delimiting...

Just add ' As a ' between the closing bracket and the 'group by'

SELECT *

FROM (

SELECT *, CHECKSUM(*) AS cs

FROM table

)as...

Often when using exists or in subqueries I use the "top 1" in the select so query eecution stops of first row retrieved.

Both servers are running Win 2000 SP4, with SQL 2000 SP3. Just to complicate things. A few months ago I configured replication between these for testing purposes and it...

I have used dynamic sql to create the required query ( as transio listed ) based on the values to be transposed. Still have not found a way to do...

I would use the vbscript task in dts to format your source file into as many different files as you have tables. Then do a simple transform task into...

If you know VBScript you could consolidate all the info into one file from the all source files in the directory and then just do one import. Just another...

If I understand this correctly, you are executing the sql on the source database which means that you need to have a odbc to the destination datavbase present on the...

May also be that on your machine you have network mappings which is not present in the sql server account. Always use fully qualified names.

Assuming you are using sql 2k I would say use a global variable to assign the date of the information you want to pull and only move those as apposed...

Looking at you post, when you do the query

@FieldValue = SELECT @FieldName FROM Jobs WHERE ID = @ID

SQL sees @FieldName as a constant not a identifier. You need...

Anbu.

I frequently have to do this type of query.

What i do is to create a temp table with an identity column.

Add required rows ordering by key columns and date.

Do...

Assuming that the SQL Agent is running, check that the account that sql agent runs under has the required rights to run the package and the induvidual tasks in the...