The killer in this problem is that a value can be used multiple times. Thus if the target value is 60 the following represent solutions:

60

30,30

30,15,15

15,15,15,15

Although your table goes in the...

Is sys.dm_exec_sessions  something SQL Server 2005 specific? On SQL Server 2000 it doesn't seem to work and  I always used master.dbo.sysprocesses to get at this sort of...

I suspect it has nothing to do with these queries but in the way ADO is used in this VB program. If you go into VB's debug mode what statement...

Didn't know there was such a thing as an implied carriage return. Maybe it's clearer to have an explicit carriage return as in

select 'Hey'+char(13)+'GO' ...

OK. Threw lots of crap it at and it seems to be holding up now.

Intuitiveness is a word. As for the 'un' prefix, dictionary says it has limitless applications.

What am I missing?

When I run

SELECT REPLACE(REPLACE('exec my_proc ''XX'',''YY''

','XX',NAME),'YY',LEFT(NAME,2)) + 'GO' FROM MASTER..SYSDATABASES WITH(NOLOCK)

WHERE DBID>5

I get

exec my_proc 'Northwind','No'

GO

exec my_proc 'VIEWS','VI'

GO

exec my_proc 'SINSYS','SI'

GO

exec my_proc 'SSB','SS'

GO

exec my_proc 'VRETE','VR'

GO

exec my_proc 'ACLATINA','AC'

GO

When I...

This falls over:

select dbo.udfToNumber('1,000',-1)

David,

On the contrary, every exchange I have on the subject of dynamic panels makes it become clearer.

But if instead of the internal variable @result I were to use @res (just...

David,

In the interest of understanding dynamic sql better and its weird syntax, if you were to write this as a normal stored procedure what would it look like?

You might be getting regional settings of the account under which the SQL Server service runs. Have you checked that?

What is the overall problem you are trying to solve? Are you are trying to write a general purpose trigger which logs changes on an arbitrary table to a central table of...

Careful with that update. It will set col3 to null when, for a record in #temp1, there is no record in #temp2. Adding a where clause will avoid this: where...

Go touch a null and you become a null. That's the rule of nulls.

Thus null +',' is equal to a null. That's why isnull(null + ',','yep') evaluates to 'yep'.

No matter...

QueryExpress: very nice little tool indeed.

Can't find anything on this 'sliding window' thing. Have you got a specific link?