Lynn -- I wonder what kind of rounding the forum used to make your post show up first?

You can build a table that contains a record for each date and hour for the time period you want to query and left join it to your login table.

Are the missing records from the end of the file or are they scattered throughout the file?  Are the 704 the ones that don't have all of the fields?  I...

search this site for pivot or crosstab query for examples.  This topic comes up a lot.  Here is a proc I use in SQL7 and 2K.  I'll get blasted for...

That is a sub I use to set step precedence so that future steps will run if I disable a middle step.  I have 50 files that come in and...

They will.  I use this to import several files depending on whether they are there or not.  If you run it from in designer they will show as  steps thet...

Instead of failing the step use activex to diable the steps you don't want to execute.

Here is an example.

sub chkfiles(flnm,tsk)

set fso=createobject("scripting.filesystemobject")

if fso.fileexists (flnm) then 

 DTSGlobalVariables.Parent.Steps("DTSStep_DTSDataPumpTask_"&tsk).DisableStep = False

 setprec "DTSStep_DTSExecuteSQLTask_2","DTSStep_DTSDataPumpTask_"&tsk

else

 DTSGlobalVariables.Parent.Steps("DTSStep_DTSDataPumpTask_"&tsk).DisableStep = True

end...

I have always found that workflow scripts are hard to manage because you can't see them in the designer.  When you go to edit old packages that you have forgotten...

it is usually better to move or rename the file with a datestamp so you have a copy for some period of time.

The answer to your second question is yes.  A...

geez, I expected something cooler

Don't lose hope.  There are a bunch of more knowledgable people than me on in the evenings.  Jeff Moden or Sergiy may have a better answer for you.

I think that means you have to set up a bunch of if statements that executes the right datediff statement based on the parameter

declare @Datepart varchar(4), @sql nvarchar(100),@res...

not sure what you mean by quoteless varchar datatype.

declare @Datepart varchar(4), @sql varchar(8000)

set @Datepart = 'yyyy'

set @sql = 'SELECT dateadd('+@Datepart+', 2, getdate())'

exec (@sql)

You would still need the DSN for access.

The way we do it is create a domain group for app users and the group gets access to the database.  That way...