You shouldn't need rowcount.

You didn't explain which data column determines the grouping. In the code I posted above, I assumed feature_sequence contains the number from 1 through 4 which determines which...

Check the security on the K: drive - make sure the user account that EM uses to connect to the server has permissions on the drive (EM executes a system...

select clientid, clientname, clientcontprimaryagtind

from tclients

Where Not Exists (

  Select *

  From tclientcontacts

  Where clientcontclientid = clientid

  And   clientcontprimaryagtind = 'Y'

)

How do you know it's an empty string in the resultset, and not 1 or more spaces ?

'' <> ' ' <> '       '

Try trimming Conutry, so that empty...

I suggest at this point you take a step back and concisely describe exactly what the problem is.

If there are blank column values in the resultset, that would imply the...

What are you expecting the results to be ? When you say "blank", do you mean an empty result set (no rows returned) or there are blanks in the returned...

PWDEncrypt() is an undocumented and unsupported built-in SqlServer function.

There is no guarantee that it will exist in future versions of SqlServer.

See BOL on the DATEDIFF() function.

Where DateDiff(dd, YourDateColumn, GetDate() ) <= 60

Your task will get easier in the new DTS (now called Integration Services) in Yukon/2005 when it is released.

eg: http://www.sqlis.com/default.aspx?23

>>Does the order of columns in the where clause have an effect on performance. 

No. To see for yourself, paste the 2 queries into Query Analyser (QA) and type CTRL-K (equivalent...

I just make use of the MDI interface in QA for this. If I have results in a grid, and I want to run a 2nd query, I CTRL-N, open...

Joint to a virtual table based off the same table:

Select feature_id feature_text,feature_sequence, feature_date

From features As f

Inner Join

  (   -- virtual table

    select  max(feature_date) As MostRecent, feature_sequence

    from features...

You could create a linked server, and run a cross-instance query of

Insert Into Target .... Select * from Source Where not Exists ...

Or you could create a DTS package, with...

See BOL on T-SQL syntax for WHILE, DECLARE CURSOR and FETCH NEXT. Using these you can build something functionally equivalent.

However, just because you can do this, doesn't mean you should.

I...

The outcome also depends on version of Sql Server, since Sql2K adheres more strictly to datatype precedence rules.

Read the BOL section titled "Data Type Precedence" - as already stated, the...