I was doing it using some very ineffective way. I was using CASE and then was concatanating with either '19' or '20' ,followed by CAST commands.

Thanks for such wonderful...

yes, it s always year after.

I have yr as Char(2).

As you suggested, I converted it to INT but then I get 01 as 1, 02 as 2 etc.. Which...

Thanks for such a quick response.

Thank you!

By 'get rid off' I meant... eliminating records which contains special characters from result set only.

NOT from the table.

Getting lnly those records which do not contain such character...

Yes. I just want to eliminate such records from result set.

A result set w/o such characters.

Thanks!

Damn, i am stupid ...that was easy. never thought of using wildcard

GilaMonster (10/14/2008)

I prefer to pick the order of columns based on how the queries filter on them.

Similarly, if a couple of frequently run queries filter A = @a...

Thank You. 🙂

Thanks for providing the code. I appreciate it.

Through the second code, I can see size of each and every index.

However, for first code, I need to have VIEW DATABASE...

Thanks you ALL for your inputs

Earlier, I also thought about issues related to Clustered Index like

- having a wide clustered index would affect performance

- it would also heavily affect...

Thank you ALL for your time and inputs. It has helped me in understanding the concepts...

Thanks

Ok, it makes sense now.

Thanks.

It seems same is true for checking Table properties...When we right click on a table from object explorer.

the row count is same as the one I...

Thanks for responding. I was able to do it.

I used Import and Export wizard. As per my case, instead of selecting a whole table, I used a query for selecting...

Thanks for your suggestion. It helped me in sorting out my issues...

probably following condition for self join

a.ID=b.ID AND

a.Link<> b.link AND

a.code1<> b.code1 OR

a.code2<> b.code2

Does this makes sense?

Btw, it just occured to me that if code1(dept_code) changes -- Link will get new...

Sorry for the confusion.

A general example to explain:

Alex (ID#1) was working under John(code2- say xxx) --dept being Finance(code1- yy) (this was in Yr 2007 & QuarterID - 1)

This record is...