Sorry that is 184,000 KB, I want to clean a free white space

My data file is 184 KB and I wanted to shrink. What is the best way to do it?

There is an option to do it mannually shrink database, is this the same thing?

My data sample

Ship Date Service...

Thank you for your help, I don't have mobile users. I would need to compare two servers staging and production, if there is any changes with data in production, call...

How is repilication works?

Thank you so much, but what ither solution do you have? The report will be created in access db and I thought populating data to the table from pivot would...

Thank you, but I don't know how to do it, can you please help me I would appreciate

I am a little confused,This is what I have:

EXECUTE sp_crosstab 'SELECT shipdate FROM tblvwUPS_package_Detail_Daily

GROUP BY shipdate', 'sum (packages)','service','tblvwUPS_package_Detail_Daily '

Where do I put :SELECT *

INTO tblvwUPS_package_Detail_DailyPackages

FROM #Rows ? Thank...

So, I have to create Table1 with the fields(values0 I will have?

I used your cross tab procedure and it work's beatifully,but how can I put results into table? Thank you

Can I create a view with calling store procedure?

I need a data in the table because, I need to create a report in Access database. Thank you

Yes, I am creating a povot. I need the data that I get from select statment, create a table with fields.

Servicedata UPS1 UPS2 UPS3 UPS4

1/1/2008 5...

2005