Though, on the other hand, it's quite practical many times that aggregates skips nulls the way they do.

Once you learn the behaviour, it's usable.

And, if nulls are excluded, there is...

Could you post the complete join? (or the complete query..)

If possible, a brief explanation of the query's purpose would also be helpful.

The subselect looks like some weird version of something...

I doubt it.

A view is something that you use for abstraction and/or security.

ie to hide and 'package' complex queries and/or use as an accessable object rather than the base table.

What...

Anything is possible, given enough time and money

Still, I'm curious as to exactly what you're trying to do..

Could you give some specific example...

This is really the long and most cumbersome way to do it, and you'll also make your transaction log grow for no use.

Why not just count it?

Declare @HowMany as int

 SELECT...

In your example there's a typo - declare @var as nvarchar(255) - (missing h)

However, if it's not that (probably not), I think that we may need to see the actual...

Integrate in what way?

Do you want to stuff the results into a table or what?

/Kenneth

Ok, so you have your app, which is most likely to be aware of which domain/user that is currently using it, but you won't bother to pick up that info...

If the users using your app are able to do a trusted logon to SQL Server by their domain/username, then it's most liekly that the app also could get this...

Looks like you're not attaching any file at all, what you're doing is that you include the results of an inline query. (@attach_results)

If you desperatley need an Excel file(?) then...

Almost, but not quite.

There's only one format that is unaware of language or datesettings - yyyymmdd

(in T-SQL it's convert style 112)

See also these articles:

How do I delimit/format dates for database...

So... do we congratulate or send our condoleanses..?

/Kenneth

Have you tried using @attachments = 'x:\miDir\myExcelFile.xls'

Haven't used xp_sendmail in years, but I can't recall that it should only work for .txt files..?

/Kenneth

Is there any reason you can't use EM? (which has this functionality) ..and also lets you decide at which level you want your script(s) generated etc... Assuming that it's DDL...

Have you continued to do the diff backups every day at 1 and 8pm?

If you have, then you should be able to restore your full backup from 20061121, and after...