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

Stewart

That's what I suspected.  Please will you post the DDL... you can change the column names if you wish.  Some sample data would be helpful, too.

John

Stewart

That query should produce an error since you're grouping by something that isn't in the select list.  Are you doing this in Query Analyzer?  Can you post the DDL for...

Beware, because if you have a stored procedure or other object called TABLENAME, you will still get the "Table Exists" message.  One way of being sure is like this:

January 22, 2007 at 2:23 am