Phil, looks like the link is broken, do you have an alternate link ? Thanks

@@Koen

Thanks for the link. and Nice to learn that derived column works faster.

@@wwei

[font="Verdana"]Thank you so much for your solution [/font], It worked just like that. I appreciate your time....

Thank You 'crazy4sql'. But I dont have rights to edit the table definition. Else I would have tried that approach. Thanks Anyways 🙂

Thanks steve , it makes sense.

One more question,What kind of problems/issues i have to face

If i leave my reporting environment in 2005 and move both Prod n Dev...

oops i forgot to paste the link ..

http://msdn.microsoft.com/en-us/library/bb510680.aspx

Iam not able to afford one for Dev too. I have some sensitive data on 2008 which needs enhanced protection thats the reason i am planing to move to 2008...

I did create the SP it was created sucesfully

And when i execute the SP with the follwoing commands

-- Index Rebuild/Reorganize

EXEC master.dbo.usp_ReorgRebuildIndexes

@databasename ='MyDBName', -- Leave the contents...

And also if you can tell me why my code failed to acheive the results that wud be great ..

Thanks

both of them throw syntax errors

First one says "Incorrect syntax near the keyword 'DESC'."

Second one says "Incorrect syntax near the keyword 'DESC'."

I never used partition by...

thanks Again.

Most of this is on paper still. But planning to implement soon.

Ideas on the " Mapping Loggic " would help too.

I decided with first 10 digits...

Intiguing Quetion Mr Rijiv

1) What is the frequency of the import/export of data to/from the 2008?

Frequency is roughly weekly.

2) During each import of the files, are the CC #'s...

YES the package is Green.

No i dont get any warnings.

YES i am looking the rigth file (the tasks that are supposed to create header and footer are working...

Thnx VR dat was helpful. 🙂

I don't have clusters though.

Thank you Robert for the useful link.

Thanks Gail.

Yes it is two seperate 146 Gigs on a RAID1.

So as of my undertsanding

a ...

Thanks Guys.

It Makes sense now.