How are you importing this into SQL?

Matt

This should do it all in one query..

select con.contact, count(con.contact) as CountOfContact from

(select studentno, count(contactid) as Contact

from StudentContact

group by studentno) con

group by con.contact

order by count(con.contact) desc

Hope this is what you...

Okay, so why dont you install the client tools on your local machine?

Matt

Edited: Sorry, i mis-read your question.

When you ran the SQL Server setup program did you select the option to install client tools?

Thats why you dont have SQL Server Management Studio.

Run the setup program again...

Im afraid so.

And i think the TIMESTAMP data type name is a bit misleading.

Matt.

The timestamp data type doesnt preserve time or date data. It is for versioning a row and is automatically populated when an insert or update takes place.

Take a look at...

The following should do the trick:

select convert(datetime, convert(varchar(4), birthyear) + '-' + convert(varchar(2), birthmonth) + '-' + convert(varchar(2), birthday))

Matt.

Thankyou Hanshi.

Ive always wondered what the N was for. Thanks.

Matt.

The answer says it's cast as nvarchar(4000) initially, but i too dont see how?

Am i missing something, or is there a typo?

Matt

Are you restarting the service from withing SSMS?

Are you a domain/local administrator on the server?

Matt

Paul,

Try this

That should encrypt the actual contents of the stored proc so the sql behind it cant be viewed. Obviously make sure this is only...

I think your best bet for this would be to create some Server DDL Triggers that monitor the creating/deletion of logins, tables and most objects.

The following MSDN article should help:...

How about using dynamic sql to generage your query within the loop?

For example:

loop

begin

set @sql_str='select * from mydatabase.dbo.mytable'

exec sp_executesql @sql_str

end

Or have i misunderstood your question?

Matt

Maybe this should be moved to the correct forum.

Out of curiosity, what is UMS ?

Matt.