Thanks a lot Jason.

Saved my day!!

On another note, could it be done using Pivot?

Thanks again.

Rahuul

Thanks Jeff. I got it.

On another note for the sake curiosity,

What would be your recommendation had it been a Standard OR Enterprise version of SQL Server (not Azure)? ...

Thanks Jeff.

The article was informative.

Per your advice, we'll go ahead and combine these tables with Partition Views.

Thanks a lot,

Rahul

Thanks Grant and Jeff.

This is an ERP system. In its current avatar, the ERP is installed in local units with their individual databases. We are planning to take the...

thanks for your replies. As you said, I can go either with TEXT datatype

or

putting description field in a different table with one to many relation.

which one would give better...

I m looking for some synchronization script. If you have please give it me.

well, I also had this problem in past. But it really dint work. What I had to do is to write a small vb prog which could run and do...

Hi Frank,

Thanks for the quick reply, I could restore from the last month backup but what about my one month data? Can I recover that? till today morning I have...

I am interested. let me know in more details (rahuularya@yahoo.com).

Hi All,

Thanks for the all your help, I recreated a field and set the identity column and Primary key, and it is all fine now!!!

Thanks much!

June 4, 2003 at 10:41 pm

#459853