Hello Ramesh,

Thanks for the comments

Hi Wayne,

How do you set adhoc query?

Thanks

So What command should I use?

Hi There,

the server that I use is 32 bits

I tried to copy your codes and run it, somehow it works...but it gives me a small error. Do you know why?

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned...

Hi There,

Can you show your way?

Thanks

Hi There,

Thanks, I did it and run the same codes that you suggested me to do

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Ole Automation Procedures', 1;

GO

RECONFIGURE;

GO

it still gives me the same error.

Thanks

can someone in here help me out for this question?

Thanks

Can someone help me with this one? I don't know what I did to make this work.

Thanks

Hi there,

can you help me with my where clause conditions?

Thanks

Hi

Yes there is a whole bunch of column fields name in where clause. But if you look carefully then it's just repeated columns such as DEClearedDate then DESecondClearedDate or DEThirdClearedDate...

If I use "Order By ISNULL(ClearedDate, '31-Dec-2090')" and place it like below:

Select SocialSecurityNumber, ClearedDate, [Type], DDS, Count(*) As TotalCleared

from #temp

Group By SocialSecurityNumber, ClearedDate, [Type], DDS

Union

Select Null, Null, Null, Null, count(*)as...

Hello,

I think I solved my problem, I use reporting service.

But there is a small thing, I just want to ask you opionion and that is:

When I changed my store...

Hello There,

This is in a report.

I wish to have a sum at the bottom of the column TotalCleared

Thanks

Hello Slange,

I have a question which relates to this question, if I want to have sum at the bottom of the column TotalCleared. Do you know how?

Thanks

Joe