That is...

It is because invisible measures can still be used, if the measure name is known.

I don't drop it, because I want to keep the old db in case the restore fails 😉

Bringing it offline and online again to drop the connections is elegant.

You need to end (kill) all other user sessions connected to the db TEST:

declare users cursor

for select spid

...

Good that you are reluctant. If you don't really need to shrink, don't shrink! 15% does not sound like much. 🙂

If you really need to shrink and the database will...

This works, unless you use #temp table names with more than two subsequent underscores or ending with an underscore:

CREATE PROCEDURE [dbo].[dtt]

AS

-- drop all #temp tables for current session

begin

DECLARE @sql VARCHAR(60),

...

I just had to choose option 3 😀

Seriously, it would fail in my environment (SQL Server 2005) but work with newer versions as stated above.

sp_msforeachtable example:

sp_msforeachtable 'SELECT ''?'' AS ''table_name'',

CONVERT(VARCHAR, [_when], 112) AS ''_when'',

COUNT(*) AS ''records''

FROM ?

GROUP BY CONVERT(VARCHAR, [_when], 112)'

Please provide us with your code and sample data from both tables.

Just guessing from what you write, you left join table2 to table1 with the _Movement_ ID.

You will first need...

Use temporary tables to store the results and check if they return something before selecting from them

SELECT 1 Test INTO #t1

SELECT 2 Test INTO #t2

DELETE #t2 --now #t2 is empty

SELECT...

Nice! I had the same Problem, but was lazy - so all I did was this (in SSRS):

=Replace(Fields!DATA.Value, "><", ">"& vbcrlf &"<")

SELECT*FROM[sysobjects]ORDER BY 1desc

or even

EXEC('SELECT*FROM[sysobjects]ORDERBY1desc')

welcome to SQL golfing - omg LOL

The second thing is especialy bad, play with the order by to see why 😀

Gsquared your "ultimate version" is much fun to read!

Now you only need to tell Jeff that you always code like that 😛

No offence taken, Jeff. But you made me think about my habits, thanks for that 🙂

Being lazy and pragmatic is a very important developer attitude to me.

I never realized...

Yeah I know - i have rewritten quite a few poorly coded loops and cursors that performed badly.

It just takes me longer and is not the first solution that pops...