Hi,

Kindly find attached the file for table structure and insert statement in txt files.

Thanks,

Sree 🙂

Hi,

Thanks for the reply and interest. 🙂

Kindly find attached files containing data in .xls file,.txt file(with data in pipe delimited format) and table structure in .txt file.

Thanks,

Sree

Hi,

Thanks for the reply.

I should have expressed it clearly or more correctly.

Is it possible to achieve it with out using multiple statements (exclude subqueries as they are part of...

Hi,

:Wow:

I am really amazed by such a overwhelming responses, guidance and more exactly help. 🙂

Thanks you all.

Sree

Hi GilaMonster,

Thanks for the reply 🙂

Can u plz go thro the below paragraphs and offer me your valuable guidance/suggestions.

When i tried to explore isolation levels i found the below stuff.

The...

Thanks Arjun 🙂

hi,

Thanks GilaMonster :).

Hi,

Thanks for your help. I've used your idea.

Rgds,

PL.Seenivasan

Hasan Mansur (5/15/2008)

---

Here is the solution you want

Create table #new(id int null, Keyvalue varchar(2),amt int)

insert into #new(id,keyvalue,amt) values (1,'aa',11)

insert into #new(id,keyvalue,amt)...

Dear All,

Thank you so much for giving me a detailed clarification 🙂

PL.Seenivasan

Hi All,

Thank you for all the valuable guidances from you.:)

Hi Thanks for your valuable time.

For the below code i get only the tariff_codes from table A

select

B.Order_No,

coalesce(C.Tariff_Code, A.Tariff_Code) [Tariff Code],

A.Unit [Actual Unit],C.Unit [Est Unit]

from

Coo_Vessel_Tariff A

full outer join Coo_Bforma_Invoice B...

When a variable is created in SQL with the declare statement it is created with no data and stored in the variable table (vtable) inside SQLs memory space. The vtable...