I have a problem to make the below data in below format using pivot

Type Week Mon Tue wed ...

Thanks friend,

The mentioned query does not meet the requirement.

If we run the query BATCH ID 121 and the ID 1 & 2 are shown which is not required.

regards

Saravanakumar.R

Thanks for your reply,

I did the same, but the performance of the query is not really good, it taking such a long time to get the result, and every row...

Again i got the same error if i have changed the sqlserver agent server as a windows authentication. i couldn;t find the result.

i have seen the HOTFIX and it was...

any hope on these ?

if any other way to run the job in TSQL? help me to resolve..

thanks

Saravanakumar.R

I'm searching in net and found the same scenario and one of the member has replied that the below quote.

http://www.developersdex.com/sql/message.asp?p=3786&ID=%3C501fdf8b-2d6d-4304-80bb-6b97feb8dfb7%40s13g2000prd.googlegroups.com%3E

Quote :

I remember with SQL Server 2000 that...

As per john suggession,

i have changed

Select lSysKey from [USUT-DB02].master.dbo.MaintananceStatus where sJulianDate = (Select max(sJulianDate) from [USUT-DB02].master.dbo.MaintananceStatus ) AND sMessage = ' ' AND lSysKey = '446'

now i...

Thanks for your response john,

i had a doubt,

if there is a problem on authentication then i could not able to run in query window ? but the case is...

I got the same error message while i am running the command in job even though i replaced the square bracket instead of "".

if any authentication problem ???

thanks...

I hope, Required the information like the method of foxpro.

select CardNo,block,crlim from tablea group by CardNo

cardno block crlim DateOpened

101 ...

I partitioned the table based on your presentation. It helps a lot about partitioning in 2005.

Thanks for your presentation and sample codes.

Few more queries on that

1.

I partitioned...

any update on this ?

regards

Saravanakumar.R

i have a basic query ! why don't we are not applied the Partitioned table instead of non partitioning table in Production Area ? is it cause any problem ?

if...

Dear Sagee,

In the production area we can't copy the entire rows from actual table to new temptable and re-upload the same from new temptable to actual table.

Any other suggestion you...