Mark-101232

Thank you for both the reference and the example.

This is exactly what I needed!

yes a record whowing the history with date rages of who reported to who and when

Wow.

Thank you for the immediate responses.

Unfortunately I abreviated the example for the sake of space.

While MIN & MAX solution will work nearly every time...

It is possible that...

So if I too can ask for help on the coattail of this thread... I have created multiple stored procs that used the sp_executesql method to write data. ...

Wow! Who needs a peer review or editorial review? 16 pages of feedback in under 48 hours!?! I think the author got the message loud and clear....

Hi Aaron

Yeah, I feel kinda stupid now. The object did have an expression set on that property. It was changing the value as soon as the expression was evaluated. I...

Hi Aaron

After reading an earlier article regarding checkpoints we have chosen to try to implement them but we are having a stifling issue. We have designated a directory on...

This is the way I would do it, but I am sure there are many more ways:

SELECT CONVERT(CHAR(6),CONVERT(SMALLDATETIME, GETDATE()), 112)

Chris - Good point - I missed that one. At least I hope the remainder of my syntax was correct (not that it will do a lick of good...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- svf_GetPriorMonthEndDate_asofdate1

-- =============================================

CREATE PROCEDURE [dbo].[svf_GetPriorMonthEndDate_asofdate1]

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements.

SET NOCOUNT ON;

DECLARE @asofdate AS DATETIME

DECLARE...

Howdy,

In SS05 you can get SSIS to log to a table instead of a text file if that would be easier. It logs information to a NON-sys table in...

I feel your pain. We had the same issue happening when fetching data into a SS05 box from an informix db running on a unix platform. As it...