The same question have been asked today (not answered yet). It's surely possible to do it. But unless it's what your application revolves around and that you have users...

What type of data did you delete?

assuming that the table is already created :

insert into #TempTable (col1, col2...) EXEC apBL_Schedule_Select 20284, 'AS', 0

check out dbcc shrinkdatabase in bols (not totally sure of the syntax).

I don't say it can't be done... but it would take so much work that I think it would be simpler to create a table with dummy col names (col001,...

Happy to have waited to try to help .

I know that the index rebuild can take up a LOT of place... but you do the shrink after that so I'm a little stumped too. Do you reindex...

Welcome to the club .

Was wondering what the h3ll was hapenning there .

I reran your code to see which one is fastest. As expected the set based approach is faster, but I also found out that your function doesn't return all...

Just a newbie question here... can't the columns of datagrid be manipulated in some way?? I know we can change the fonts/colors... but is there a way to change...

Tried that... but I couldn't make it work. But as long as you have better luck than me then it's all good

The only way I found to count that is to set a global variable and increment it on the group_format event. Then you can set the number manually once...

Prerun the query to find the columns to hide.

Remake the sql statement with dynamic sql and run that statement. This will be a pain to code really.

I disagree (hey you can't be right right away ).

I redid it on one of my reports.

Open the group by wizard in the menu

check display header/footer for the employees group

in the footer add this :

=Average([ColName]) (might me AVG()...