I have done some minor alterations to the stored procedure:

1.Instead of updating table #t1 and then insert into #t2, the new one directly inserts the chosen columns into #t2.

2.It made...

Hi,

I know you did say you don’t want an answer with dynamic statement for fear of SQL injection. As I can’t think of any way to select the empty columns...

Thanks for your advices.

First, I didn’t understand about the “hijacking” part until you point it out. I’ll remember that in my future new posting.

Second, I am aware of the ability...

Recently, I have tried to work around this problem using the following approach:

•I moved all the SQL stored procedures to Entity Framework 4.0 using Visual Studio 2010 and SQL 2008...

I have found out how to tell the broadcasting time. On the left side of this posting, there is an item "Last logged in time". For me it says 4:13...

Please advise what time zone is the web seminars broadcasted. We may be sleeping when they are on, or it may fall in the working hours so that we need...

Thanks for the interesting article.

Recently I have experimented with derived table and also table variable.

For the simple examples below, using derived table, the query took about 1 min 17 sec...