Hello Hans,

offhand and not knowing your database I can think of two reasons for such construct (although I'm not sure whether it can work this way in a SP... but...

Noeld's solution seems to be fine - there is just one question about the word "previous" in original post.

In case the records are not always ordered by date ascending, and...

In case there are Groups with no members (no corresponding entry in Customerdtl) and you want to display these as well :

SELECT g.GroupId, count(c.CustRpt)

FROM CustomerGroup g

LEFT JOIN Customerdtl c ON...

That's strange... I never had problems shrinking tempdb via EM. My standard action is : Shrink database/Files, then select "Shrink file to", set the size (e.g. 5000), then OK, and then Cancel....

Hmm... if it's just the application that can't access those tables, couldn't there be some issue with table ownership (e.g. all other tables your application uses having owner BBQ, while your...

As far as I can tell, AUTO SHRINK is not a good option in most cases. It slows down the server - sometimes rather drastically - when the system decides...

DAV,

your solution is remarkably similar to that of Kenneth :-)) But I agree, this is what I prefer, too. I need such conversion quite often, and in the beginning I...

I agree, this question (or rather supplied answers) was not entirely correct. To pick an "odd man" out, there has to be only one of them. The question in question...

Sure, of course you can. Open your job, then the respective step and enter the SQL into "Command" field - all including DECLARE etc. - it works fine.

What about this (assuming that originally the respective step command was "EXEC some_procedure") :

DECLARE @today datetime

SELECT @today = GETDATE()

IF MONTH(@today) = MONTH(@today + 1)

BEGIN

EXEC some_procedure

END

If it is the last of the...

Hello Cory,

I can't explain why it is so, and whether it is a bug or not, but that's how it works :-). I've seen this many times, so it seems...

That's how I understood it, Antares... in fact that means that the name of the function is a bit misleading. It is easy to understand that as "contains only numbers",...

That's really strange... it only returns 1, if there is just one occurence of the character D or E, and it starts to evaluate as Not numeric if more than...

Hello Thor,

I don't fully understand the structure and the way you want to display missing days, but I'll try. I see there is some cursor used to fetch rows... well, that...

Hello Dave,

look at "Database Object Owner" - as far as I know, the same rules apply to all objects. Also, look at "Programming Stored Procedures" (qualifying names inside stored procedure)...