Note that there is a typo in step three.  Drop the last ' mark.

A couple of things.  This isn't general purpose, the only reason it works is because there aren't...

Aruna, I hoped you picked up from the other comments that the clear text password is given by the person trying to get access.

The Improvements section isn't clear.  Are you...

Why do you have the banner (row 1) cells defined in the loop?

I'm fairly new to SQL Server, but not new to SQL.  Didn't know about the debugger before, not impressed with it now.  If it worked, I'd be more impressed with it.

I...

I've had similar experiences with improving cursors.  I had to look at someone's report because they weren't getting good data from it anymore.  I ran the existing proc on my...

After the pivot the results data would look like this...

ID Result

-- ----------------

56 run, jump, scale

No, not really, it should look like:

ID Result

-- ----------------

56 run,jump,scale,

That's 15 characters long, and if the...

You said in your article that you think C# is case sensitive.  For the most part, that's true.  The one place where it isn't true is on the data filter...

I'd replace the section of code:

 If exists(select [Name] from tempdb.dbo.sysobjects where [name] = '##TEMPCOUNT')

 DROP TABLE ##TEMPCOUNT

 set @sql = 'Select COUNT(*) as COUNT into ##TEMPCOUNT from ' + @tablename

 set...

If I understand correctly, we are not talking about 300-500K, that's the approximate number of records in one table.  You also said that on average about 100 bytes per record. ...

I see Stewart Joslyn came up with the same answer as I did.  (I "created" his second solution.)

I also agree with spongemagnet AKA "Ken" that SQL should know better.  When...

Sorry "...ON DELETE NO ACTION for the employee/Device..." should read "...ON DELETE NO ACTION for the Rooms/Device..."

I'm really late responding to this note.  I'm just now having the same problem, so I was looking for an explanation of why SQL did it this way.  Sorry if...

My statements are pretty muddled maybe an example will help

Before I did anything to the proc, the result of 'sp_depends proc_of_interest' is:

In the current database, the specified object is referenced...

Remi, I haven't seen (don't remember?) using a function to build a column in a table.

So, internally DOB_MD is stored as a smallint field.  Inserting without specifying DOB_MD obviously calculates the value.

I...

tzara  says

select * from orders

where Datepart(mm, orderdate) between 2 and 5

and Datepart(dd, orderdate) between 1 and 15

order by Datepart(mm, orderdate), Datepart(dd,...