You could try running sp_recompile on your procedure.

Also you have

(select x1 from table1 where val1=main.val1 and weeknum=1),

(select y1 from table1, where val1=main.val1 and weeknum=1),

If this is literally what...

Permissions are assigned to the user so provided that you NT user has logon authority to your SQL box then you should be OK.

As a general point I would assign...

You will need either C++ or Delphi experience to create the extended stored procedures.

The libraries for SQL Server 7 and SQL Server 2000 are different.

I would go with the suggestion...

Are there no combinations of columns in the table that could constitute a unique key?

Couldn't transactionid and trandate consitute a unqiue key?

If you could describe in more detail what it is...

It isn't quite as simple as that.

If your single table breaks normalisation rules then anything you gain on ease of retrieval will be lost on the difficulty of maintaining the...

Unless you class the CAST(dbo.Tokens.Spams AS NUMERIC(18.4)) as simpler, no.

The only time I use CONVERT these days is for Date conversions

CREATE PROC usp_setScore AS

SET NOCOUNT ON -- Suppress record count messages for a performance boost.

--  Declare two variables.

DECLARE @lGoodMails Int , @lBadMails Int

--  Populate the variables with values from table1

SELECT...

Part of my test plans for development includes unit testing my stored procedures with known parameters and comparing the expected results with the actual results.

OK, in a production environment you...

Yes,

If you grant access via database roles then deny write access to the view for that particular role.

If you grant access to users (after a smack on the wrist) deny...

Kenneth, try using BETWEEN on a column with a clustered index and then comparing the > and < method.

If your SELECT involves a single table then you should be able to Add.

Make sure that whatever user you are connecting to the database has read/write access.

Your best bet is...

When it comes to WHERE clauses I have found that the different comparison operators have different performances.  In order of speed (fastest first)

1. =
2. > or <
3. <> or !=

If you can...

Theoretically you could simply run the Access upsizing wizard http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0561.mspx

I would start by reading up about the different datatypes in SQL Server and mapping them to the various MS...

When the proc is called from your application open up SQL Query Analyser and run sp_lock and sp_who to see what is going on.

Within Enterprise Manager have a look at...

If your users are administrator then you have big problems.

If you want to block Access and Excel usage then what rights should they legitimately hold?

What logon are they using?  Why...