How about a separate, simple process (scheduled batch file, even) that moves (not copy) the file to the SAN?

In your "other" stored proc, you can execute this stored proc and put the result set in a temp table. eg:

create proc myotherproc as

create table #temp (member_id int, hcc int)

insert...

Why are the last 2 columns subselects, instead of 2 more joins? Joining the tables (even outer joins) may be more efficient than subselects.

Depending on the size of the tables...

After you successfully change the name in EM, double click the view to enter "properties" and change the name CREATE statement as well.

I think this formatting is coming from your operating system. Try changing the date display in Windows regional settings. Regardless, it should still sort properly as it sorts on the...

A quick and dirty method is to script the database object(s) and do a simple dos text compare.

Where is c:\Comprime? xp_cmdshell will execute on the SQL server machine in the context of the SQL server user account. If the exe is on some other machine (your desktop,...

You could try:

where (personurn <= 590) or (personurn between 592 and 594) or (personurn >= 596)

but I don't know if it would be much more efficient

The clustered index defines the native physical order of the data on the disk. Consequently, there can be only one clustered index on each table. All other indexes on a table...

The posted solutions seem overly complicated to me. I'd do something like this:

select datepart(mm, convert(datetime, convert(varchar(2), MonthNumberColumn) + '/20/2006')) from MonthNumberTable

The day and year in the string ('/20/2006') don't really...

This is just a guess from your description, but this is a common problem with DTS:

Whenever you access something that is specific to a machine, like a flat file in...

If you want this to happen to every value that is entered into the database, you may want to consider an insert and/or update trigger. This is code that is...