I remember now why I didn't respond to this post originally. This sentence:

worried me - the...

karthikeyan-444867 (11/23/2011)

---

I would like to delete the securities from the table where as the returns are only NULL from 01/JAN/2000 to tilldate.

Note all the securties will have the returns from...

I still don't know the answer to this.

To Karthik: please post your exact question clearly, without expecting us to guess it based on your scenario.

OK - but I asked about the column names and I'm not sure that you've tried what I suggested.

In your SQL for the extraction from the view, try aliasing the...

That's not...

Could it be a problem with spaces in the column names?

I had to do something very similar recently. Check this thread for a fast T-SQL solution (and many other interesting suggestions!)

Hi Jason

This stuff is much easier to read if you use code="sql" tags (+ thanks to SQL Prompt for reformatting):

declare @ServerName as varchar(60)

set @servername = 'yourservernamehere'

create table TEMPDB.dbo.tFreeSpace

(

...

In the absence of a question in your post, it seems that the import/export (or should that be export/import) method is the one to use.

True for 2003. 2007 onwards allow 16,384 columns, requiring a truly microscopic font in SSRS 😛

Good answer, but note that you have answered a question which is more than a year old 🙂

What do you mean by 'remote'? Outside of your LAN?

And, especially around the middle of the afternoon, or when you accidentally pressed F5 while connected to production, DUMP.

I'm still a little puzzled.

I create a new Excel Workbook from scratch.

I import the Pivot Tables into 7 different sheets and the size grows to 116MB even though I deleted...

Welsh Corgi (11/7/2011)

---

I'm loading multiple Sheets into an Excel File from SQL Server.

The macro listed below will reset the used cell ranges and should reduce the File Size.

I can't...