just to throw my two since in I think that if you are doing a full blown table with dates then this is a better option this is particularly useful...

K big question time.

In you example ID 683 starts on the 1st but does not stop till the 2nd.

When will this query be run and how would this record be...

In SSIS there is a pretty easy way to do this. In the control tab first do a select count(*) in an SQL task. save the output to...

If you are saying you got a raise last year, are going to get (or atleast it sounds like) this year and plan or hope to get one next year...

It is very likely that this is over simplyfied based on the example. If there are 100 questions I do not recommend doing a sub query for each, however...

I would suspect that if you remove the Query field from the select statement it would speed up almost immediately. I also suspect that if you look at the...

That list is cracking me up. Anti-Boredom Month roflmao!! 😀

Steve you haven't heard to fix the budget the Gov is going to allow moths to be sponsored. next month will not be july it will be City Bank...

assuming I have understood you correctly the following would eliminate any row that is all 0's or all 9's regardless of length.

select * from @sample where

string <> Replicate('0',len(string))

and

string <> Replicate('9',len(string))

Just to clarify you want to ignore only if it is all 0 or all 9

Hopefully I am not over simplifying this but the following code would work assuming the data is as straight forward as my sample data.

declare @sample table

(string varchar(10))

insert into @sample (string)...

do you log your jobs? was there and error? There could be a couple hundred reasons why it might have failed but with out some more information you...

HAving been in management more often than I care to think about I would offer the following perspective.

If I where you I would simply define a reasonable timeline and clear...

I had never tried it with 2008 based on my mis guided beleif that support had been removed (which I was fine with) and so I tried to set...

based on the link you provided It looks like this was an after thought. I know I recall reading somwhere pre release that DTS would not be supported but...