Hugo Kornelis (5/8/2009)

---

No...

I got it wrong because I thought TWO NULL Values are NOT supposed to be same(identical). So I chose the option with 3 rows. Quirk of SQLServer?

vidhyasudha (4/30/2009)

---

Here are my table scripts.

CREATE TABLE Product

(

product_id varchar(20), --- Primary key

product_name varchar(30)

Constraint PK_product_id Primary Key

) ON Primary

Create TABLE Sku

(

sku_id varchar(20), ...

Point taken. That was just an after thought. That's the way I had read the requirement, even though as you mention, the OP had indeed not mentioned this as a...

Anything that I enclose in [] has to be numeric otherwise SS throws an error. In your solution you are using Sql variable as well as hardcoding the subscript TO[sql...

lmu92 (4/28/2009)

---

Hi,

did you try the PATINDEX function?

The following code will check the start position of each value from your table within the given search string. It will return the max....

Thanks that's a good point worth being on the lookout for.

steve dassin (4/26/2009)

---

saurabh.dwivedy (4/25/2009)

---

Because ideally I am invoking the same principle that is generally applied in SQL anywhere...viz "the property of closure", something which forms the basis of nested statements...

Thanks Lutz. I understand the substring part. I was trying to make sense of the 1000 part. Anyway I have got it now. Thanks for taking the time to explain.

Ken Simmons (4/26/2009)

---

There are a couple of ways you can do this. Here is one example.

Declare @Table Table (id int, color varchar(10))

Insert Into @Table

Select 1, 'red' UNION ALL

Select 1, 'blue'...

after some testing on dev I found without begin tran if i use Xact_abort on the transactions are rolled back for a single transaction like insert, update or delete but...

I will attempt to answer this question: I have gone thru the link posted in this thread and my answer is based on the understanding derived from that msdn article....

As has been mentioned by Mr Corbett, I don't think GO...

Arup,

You can always mask your code in such a way that the proprietary information is not revealed. It would be helpful especially to newbies like myself to learn practical solutions...

Thanks Jeff...I learnt something new again.