Yes and in my last post...I just don't have the energy to turn that into...

itortu (8/2/2016)

---

The sub_category_column is contained in the same table. No other table is missing.

For example, column sub_category_of with value of 930, it belongs to "Guitar/Fretted Strings", which also has...

Aside the sub-category which isn't present in your sample data I think something as simple as this might be what you are looking for.

select *

from instrument_ref i

join instrument_ref d...

Yeah I suspect there is a sub-category table involved here that we don't have....

As posted your sample data is not in a format that is consumable. Here is the table and data in a format that is readily consumable.

CREATE TABLE [dbo].[instrument_ref](

[instrument_id] [int] IDENTITY(1,1)...

tskelley (7/29/2016)

---

Thanks for the quick reply. My problem is not so much with the functionality of ISNULL with a concatenated field. My problem is the syntax I need...

ChrisM@Work (7/29/2016)

---

Sean Lange (7/29/2016)

---

ChrisM@Work (7/29/2016)

---

It's Friday, you can get anything you...

I would...

Sweet!!! Maybe I can get banned!?!?!?!?!

joeroshan (7/29/2016)

---

Sean, I think dastagiri is asking about rebuilding indexes.

Unless you give online option, the table will be locked until the clustered index is rebuilt.

With online option there will locks...

Good grief...the spammers are out in force today.

DEEPAK GUPTA-378433 (7/29/2016)

---

Hello All

How could I use Column for Table1 within subquery. I know this is not possible but there should be a nice way to achieve this.

SELECT *

FROM Table1...

dastagiri16 (7/28/2016)

---

I have to run the below command in production environment.

Alter table table_name Rebuild

but my applications are continuously hitting that table so will my table is accessible for applications...

curious_sqldba (7/28/2016)

---

I have looked online and on this forum but couldn't find exactly what i am looking for. I need a script that will dump definition of all the objects...

Slight side track here. I noticed you named your procedure with the SP_ prefix. This can cause some issues. You should consider using a different prefix, or even better no...