With this statement:

Set @strSQL = 'SELECT FullName as UserFullName FROM Users'

Set @strSQL = @strSQL + ' WHERE USERID = ''' + @ID + ''''

Set @strSQL = @strSQL + @WhereClause

Imagin...

First, is it stored as text or a number?

That statement looks very prone to SQL injection attacks.

Your best bet is to pull the data into an app, process it, then store the result. If it really must be done by the sql server I suppose you...

I think your first step must be to find out exactly what equations are being done (both the explicit ones wrote for the solver and the implicit ones carried out...

Another approch is to have two columns in the EventAttempt table, EventID and EventType. Then you could use insert/update/delete triggers to check for ophaned rows.

Your only trouble is that the server doesn't really know what application is accessing it, it only receives sql. I would imagin that if anyone wanted to cause some trouble...

Nevermind, finally found the reason for this problem. Sql Server Mobile doesn't install the required dll "sqlceoledb30.dll" when installing from the cab files.

I installed this file manually by copying it...

I've never found the ads too obtrusive here. Primarly because they don't pop up everywhere or cause epileptic fits whilst reading the page

Also...

Firstly, KeyID looks to be always unique, thus could you not remove FirstName and LastName from the primary key and create a unique constraint on these two columns?

As for automatically...

On way:

SELECT * FROM dbo.tblClaims_eligible

WHERE (@memberid IS null OR membid = @memberid)

If you pass @memberid as null the first half will always evaluate to true, thus it won't test the...

You'll have to use an instead of update trigger to modify the underlying tables

numeric type in SQL server is the same as decimal, what's the problem?

If it's a proper temp table (name starts with #) it will be deleted when the connection is closed or goes out of the scope that created it (can't remember...

Green with play = server is running

Red with stop = server is not running

Gray circle = unknown, being a remote server management studio hasn't tried to connect to it yet, thus...