well for some reason my link is not working but here is the script from Michael Valentine Jones

-- Script to analyze table space usage using the

-- output from the sp_spaceused...

The following article is a great source for that.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

you can declare a varialbe with the below. you will have to research them though and see what the appropriate data type is for the table.

Declare @Name VarChar(50)

Set @name='Mighty...

I should really pay attention to things like this. OK in SSMS if you highlight and the right click a section of code you can select create region and...

While there are likely some form of SQL code editors that would do such a thing. There is nothing that ships with SQL that would allow you to do...

with my boss a great way to close any topic is to bring up money. That stops the conversation dead. I have never found a better topic ender.

This might be overkill but here is an article that might be of interest to you. A forum post reminded me to it's existance.

http://www.sqlservercentral.com/articles/Full-Text+Search+(2008)/64248/

enjoy

SELECT so.name, si.rows FROM sysindexes si

left join sysobjects so on si.id = so.id

WHERE so.type =...

answering this questions requires a bit more information. What is the point of the type of bread or sugar? Can that be gotten from a table? If...

actually it should be a LEFT OUTER JOIN now that I think about it. That way if a record is not returned in one case it will inslude the...

using The buzz word of the day from yesterday we shall use this as a mentoring moment ya.

so if you look at my joins you will see person_user u1. ...

I like your responce to a bad situation. I often feal bad for the ticket agent in airports as they get screamed at. I think people forget that...

I just realised I messed up the alias in the joins. did you happen to correct those? If not I am rather surpriesed it did not give you an...

what does it do?

Assuming you what to return the last check for every person then you could do something like below.

declare @temp table (fristname varchar(20),lastname varchar(20),Check_date

...