Crud... didn't see it before but Vladan beat me to the explanation for Cory a long time ago... sorry.

Because GETDATE() has a time associated with it.  The want all of yesterday... in order to do that, you must strip the time back to midnight of yesterday... all that...

There's probably a dozen ways... here's a couple without UDF or Tally table...

declare @table table (ad_str1 varchar(50))

insert @table

select 'apple avenue w' union all

select 'melon road e' union all

select...

Junkie,

Would you post the query that creates the example output that you posted?  I think that's probably the key, here.

Nicasio,

In order for the EXE to release it's grip, it must close connections, destroy the connections, AND successfully exit the command processor window you've invoked.  When you run it as...

What ever you make with a permanent table, should also work with a temp table except FK constraints.

Actually, Martin gave you the previous answer... but thank you, anyway.

I've not had the time to "play" with it, but you are missing a column alias in your stored procedure which...

Absolutely outstanding article, Sushila... Your fine article should be the one that is required reading, not only for the "newbies", but for many of us old hacks as a reminder...

Long term transactions will cause huge wait periods and, possibly, deadlocks.  I like Sreejith's method and have used it before... we used a column called "IsDirty" and it contained the...

The way you have it written, you are trying to insert into a temp table and variables at the same time.  If you want to do both, you will need...

Be aware that when you change a diagram and save it, it actually updates your database to match... diagrams are really a form of somewhat anorexic data models.

Another possibility would be to use a "Linked Server" which would also hide the login and password from prying eyes.

That's a good start... got any data we can play with and, like I asked, are the tests stored in the same table as the quizzes?  If so, what marks...

Where is the Test info stored?  In the QuizLog?

Sidebar... does you table actually have columns with spaces in the names ?

I think it...