This is fairly straightforward.  You do not need separate databases for this information, even if the number of schools gets very large - you will find that having everything in...

Please do not submit the same post in multiple forums.

Use this link for answers to this question:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=225720

This isn't very elegant but it works.  You'll notice that the calculation of @totalmins at the end relies on integer division - related to the MOD function that you are...

Try this - untested, but should get you going:

select r1.*

from server1.database1.information_schema.routines r1

left join server2.database2.information_schema.routines r2

on r1.routine_name = r2.routine_name and r1.routine_type = r2.routine_type

where r1.routine_type = 'procedure' and (r2.routine_name is null)

Why not just detach the dbs on the old computer, copy them across using Explorer and then attach on the new PC?  This takes SQL Server out of the equation.

Also,...

Using EM to input data, CTRL/0 will enter a NULL for you.

If you are really concerned, I guess you could write a trigger that will always convert space to NULL,...

SQL Server recognises a space as being different from a null (because it is).  Why don't you just configure your app to convert a space to a null and write...

Can't find a way of doing this without using sysfiles - here's an example, if you need it:

declare @dbname varchar(100)

declare @strSQL nvarchar(500)

set @dbname = 'master'

set @strSQL = 'select name, fileid,...

What you are trying to do is a little more complex than this - though this gets a bit closer, I think:

declare @table varchar(50)

declare @str1 nvarchar(1000)

set @table = 'test_table'

set @str1...

I've never seen this message before - you've got something strange happening there!  All I can suggest is that you remove transformations one at a time and keep trying ......

If you are writing the code as part of an ActiveX script, the & character is used to concatenate strings, not + (just to keep you on your toes)!

Suggest you modify your queries to remove any likelihood of ambiguity between column names.  Do this by prefixing the column name with the table name:

select tablename.columnname from tablename

If the table...

You can check this easily in EM.  Just open Security/Logins, right click the user of interest and select properties and you will see the default database.

You will not achieve this type of formatting with straightforward SQL statements - Ray M's solution, possibly with an additional ORDER BY clause so that you get everything in date...

update no

set status = 2

from n_order no join n_inv ni on no.id = ni.id

where (ni.tf is not null or exists (select bt.debtkey from banktable bt where bt.debtkey = ni.debtkey))