Amazing Gail...

I have been looking for an article on Indexes as simple and exhaustive as this for long.

Looking forward to the next 2 parts.

Thanks

If all the data is the same except the dates which row should be chosen?

I am wondering why you think this design is not perfect......

Hope so, I wanted to restart the service at that moment but was apprehensive as there were releases to be made that day. Didnt want the whole thing to conk...

Its working fine now after restarting the SQL Server Service.

Thanks.

SQL Server 2000.

I am viewing this in the enterprise manager.

My sps start with Gsp_

Please see attachment.

When I create a stored procedure it is getting marked as a system stored procedure, as in the type is getting reflected as 'System' instead of 'User'.

Is there any setting...

Hi,

Does anyone know how I can pull just the numeric value from a varchar field which contains both numeric and characters?

eg.

if the data stored was:

"40 Words"

or if the data stored...

what if it was "40 Words 60" , what should the output be?

see if this article helps

http://www.sqlservercentral.com/articles/Test+Data/61572/

Would this help

SELECT a.widthdata AS col1,

b.widthdata AS col2,

c.widthdata AS col3

from dimlab1 a

inner join dimlab2 b

on a.idno = b.idno

inner join...

Would the number of rows always remain the same in all tables?

Suggestion: Please don't edit the post in a way by which the continuity of the thread is affected.

please look up the deleted and inserted logical tables used by DML triggers.

"Student","Subject", "Pass" , "Fail"....

Looks like a homework question.....

wouldn't it be better to generate a script of the said procedures and do a replace for varchar(255) with varchar(2000) and execute them.

I don't think it is advisable to modify...