Thanks Jeff.

Yes, they are on different filegroups.

Thank you Jeff,

Can we do offline rebuild of partation in SQL 2008 Version with the below syntax?

ALTER INDEX IX_TransactionHistory_TransactionDate

ON Production.TransactionHistory

REBUILD Partition = 5

Hello Jeff,

Thanks for the response.

We don't have scheduled maintenance due to the nature of environment and will be done on planned adhoc basis. The earlier partations are in good...

Thanks very much for your response Shawn.

Thanks very much Shawn.

Can same be achieved through sc?

Thanks in advance.

Thanks Jeff.

I tried to find ACE Drivers details but not able to find much. Please let me know the web links where I can gain more inforamtion.

Regards,

Paul

Thanks very much Alan.

Management don't want to move Access data to SQL Server. It would be great if you could help me in using JET OLEDB in SQL 2012.

Regards,

Paul

All,

I could able to figure out and complete the task.

Thanks

Sorry All.

I could able to figure out the fix and taken care of it.

Thanks very much. It should help.

Regards,

Hello Lynn,

Thanks for your response.

Below is the syntax of the original query.

SELECT A.COL1, A.COL2, B.COL3, B.COL4 FROM TABLE A JOIN TABLE B ON A.DATE_CREATED = B.DATE_CREATED

Thanks in advance,

Yes. Right now I could able to figure out.

I may need your help in the near futher. Right now I am not clear about the requirement. Once I have...

Thanks...

When trying at my end, the below query worked for me...

SELECT A.COL1, B.COL2,C.COL3, A.COL4, B.COL5, C.COL6,

CASE WHEN D.COL1 = 1 THEN E.NAME ELSE ' ' END [INVEST1],

CASE WHEN...

Hi,

I don't want to UNION here instead I want to get the output from both the query in single query. I want to add both query into one so that...

adding to the below email.

I have linked server configured between instance1 and instance2. In 2nd select statement, I am going to use [Instance.database.dbo.table] in the case statement. As the...