Yes, the table will have values like (08,A), (09,A) etc...

sorry but I didn't get the idea of creating unique constraint on Look up table and relating main table with it.

I...

Thanks!

I figured out.. 🙂

Very weird.

Since this was small table, I was able to do this work around.

But i am trying to understand what cud hav been reason for the error message

No.

I thought about that. So, I even closed the BIDS but still I was getting the error.

And it came up even when I restarted my local machine.

I checked...

{ direction: RTL

writingmode : tb-rl } does the trick

I also went thru properties... no such option.

🙁

thanks for your time

Just a wild guess.. Can we use Properties>TextAlign>Expressions. though there isn't any in-built function available

if i change temp table to global temp table, it works.

I tried using sproc in BCP..but i am getting an error saying 'invalid object name'

Am I missing some trick? I read in some forums.. about SET FMTONLY ON/OFF

btw, this is...

Bob & Jeff,Thanks!

I'll try these methods. thank you

that's the problem. These resultsets are huge..

I also thought about dumping result into non-temp table and then performing desired transformation. But for big result set, i don't know if its...

Thanks for suggestion. I think I'll go with exploring sub report option.

thanks

it worked.

thanks!!

RTRIM & LTRIM does the trick.

gotcha!

hi there,

I am getting each DB name in result. but not the table names.

It shows me name of only those tables against which I am running query. For example: if...