Create a table With SSN and an identity column. Make sure that the SSN is the Primary Key and use the table as a Lookup

Select STUDENT

, Min(CLASS1) as Cls1

, Min(CLASS2) as Cls2

, Min(CLASS3) as Cls3

, Min(CLASS4) as Cls4

, Min(CLASS5) as Cls5

, Min(CLASS6) as Cls6

From #TEMP

Group by STUDENT

I would...

The Q is just to  Alias the Subquery

select EmployerID,EmployeeID,EmployeeInfo, Count(*) as TCnt

from [YourTable]

group by EmployerID,EmployeeID,EmployeeInfo

Having Count(*) > 1

order by EmployeeID,TCnt desc

how about :

select count(distinct fund)

FROM

((select fund from tableA Where ....)

Union

(select fund from tableB where....)) Q

It is really small !

Chris, I am glad to hear from you!

 The other side of the story is that then 24x7 is...

THANK YOU Guys for your input!!!!

When a Patch has to be applied we  apply patches to the pasive, fail over then to the other  apply patch there and we...

SQLBill,

Thank you very much for your input. I would do exactly as you mentioned but I am NOT allowed to change ANY SQL Code in production until tested and validated on...

The probelm seems to be that a procedure got slower (a lot)  and due to that I think an index defrag would help. Now, I am NOT allowed to stop...

you can create a function to parse the string.

this one was taken from the script library on this site and adapted to your case:

CREATE FUNCTION dbo.udf_GetValueFromList( @List varchar(1000), @position int)

RETURNS...

you may want to consider this script

exec sp_MSforeachdb 'use ? 

  insert into Admin.dbo.contigInfo

  ( ObjectName ,

   ObjectId ,

   IndexName,

   IndexId,

  ...

Just Create A tempTable with the structure of the Recordset returned by the sp and use the insert exec construct like:

declare @TimesToRun int

you can create ethier a COM object and use sp_OA procedures to call it or write an extended stored procedure install it on the master and call it using the...

How about a Lookup Table

  Location2, Grade, TeacherID, SPercentage

And join that to   tblMMrptStanResultsGrade

I don't think you can map a network drive from a service! Mapped drives info is  strored at profile level which by the way services are not aware of. That...