Please don't cross post.

Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1315101-150-1.aspx

What error are you getting? You can have IIS7 send error messages to the browser for debugging purposes. Just open the ASP item in IIS and then expand Debugging. You...

Yeah I would think you might get a couple dozen more page loads in a month span. Not even a drop in the bucket for a site with as much...

ChrisM@Work (6/13/2012)

Anatoly Ukhvanov (6/13/2012)

Thanks, I'll «store it in my mind». 🙂

P. S. Did I choose the correct English idiom? Do American/English people say like this?...

And your response? Again there is no correct answer, except to be honest.

It seems that it would be nearly impossible to have an idea of how many potential readers you don't get because they don't want to register. I know that from...

If I was asked that question in an interview I would hope the person asking is ready for a deluge of questions coming back. There is not much to go...

Here is a simple example...

DECLARE @cmd NVARCHAR(255)

SET @cmd = 'This string has it''s content escape''d so it won''t have an issue.'

SELECT @cmd

Hi and welcome to SSC! The first step to finding your answer is to read the first article linked in my signature.

Also Why are you using inner loop joins? Those loop joins can be a major performance issue unless you are 100% certain (and can explain) why you need that join...

I would also suggest what Gus said but to add to that, your original query is selecting top but there is no order by. This means your max was not...

Yeap clear as mud. Just once it would be nice if you actually followed the advice you offer to others by actually reading the article you...

Notice how Anthony posted sample data? It is readily consumable so nobody has to generate based off what you typed. From your description it seems like you could use something...

First thing I would suggest is to replace your split function with the one in the article I reference in my signature. Then to get your data you will want...

Methew (6/12/2012)

dwain.c (6/12/2012)

Well, it's not like Inserted.ID is...