John

Best just to insert the new records.  Is your data date-stamped?  If so, you can write your insert query based on the date.  If not, you will indeed need some...

You should have an icon in Control Panel called SQL Server 2000 Licensing Setup.

John

John

Set up your AS/400 server as a linked server and then create a job to copy data to your table weekly.  Or create a DTS package to do the same...

USE master

GO

SELECT DB_ID(MyDB)

John

Your queries don't make sense.  They don't specify what update to perform.  For example, the second query should read something like this:

update T set myCol = 40

where id = 32...

You will have to mess with dynamic SQL and fiddly datepart functions.  It can be done, but if you want to keep it simple, probably best to use a database...

Yes, that is the essence of what the indexed view is.  See Books Online for more details.  Of course the other important thing about it is that it is indexed...

This should work, although I haven't tested it.  I don't know how it'll perform on a large table.  I can't think of a way without using dynamic SQL to select...

That you are asking for every 100th SessionID suggests that your data is ordered in some way.  If not, what does "every 100th" mean?  And please confirm that you want...

Oblio

So you have two "unknowns" - the % in the middle, which can be any number of characters, and one single unknown character at the end.  The best way of...

Ron

Look up the DATEADD, DATEDIFF and DATEPART functions.

John

Michael

I'm assuming that for any given UserId, FirstName And FamilyName will always be the same.  If that's the case, your database isn't properly normalised and you should create a separate...

Just to explain to those who aren't familiar with UK postcodes...

The first part of the postcode can have 2, 3 or 4 characters; the second part always has 3: a...

What Connection Type are you using?  Have a look at this and see if it helps:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101249&SiteID=1

John

Please will you post the two queries if you can, as well as a description of what input/output parameters and global variables you are using.

Thanks

John