Thanks Herald...It was ma luck that I also did not try to relate it...:-)

Thank you for the answers and for the advise too..I take it for sure.

Koen, I have told them the answers. The answers I told them are not exactly like you...

I am very sure, that they asked me like that. Because , I asked them twice to make sure that I heard what exactly they asked.

I told them the...

Sorry Steve...

I was just telling the questions, I was asked. But I am really not having answer for the first and third question.

1. Difference between OLEDB and OLAP....May be I...

Thank you Eirik....I really appreciate your help.

Eirik, Could you please elaborate me ?

Yes Steve, It's mess...but I had no idea so I am just asking if we have any way to do that

NO Steve, the problem is one field is IsSortSeqNo and another one named like ISSortSeqNo...

If you noticed, the second letter of the field name is upper and lower case.

So SSIS...

Hi Eirik,

First of all thanks to you because you have taught me new functions like unbounded. and a new way of writing query.....I have never heard about that....

Hi Chris,

The query you have given is really easy to understand....Thank you so much..

ScottPletcher (4/3/2014)

---

I prefer to avoid anything that is date or language setting dependent; DATEDIFF(DAY, 0, first_day_of_month) % 7 will yield a value that never changes no matter what the SQL...

Hi Koen,

This is the script I used.

EXECUTE sys.sp_cdc_enable_db

go

EXECUTE sys.sp_cdc_enable_table

@source_schema = N'dbo',

@source_name = 'tablename',

@role_name = NULL

yes Of course, Wayne. We (beginners) must say thanks not you. As a beginner in learning SQL, it was very helpful to me. And I have been scheduled for an...

Hi Wayne,

It's really a great and quite interesting article. Very clear cut explanation of understanding the dead lock with examples. I really enjoyed and clearly understood what a dead lock...

Hi Wayne,

It's really a great and quite interesting article. Very clear cut explanation of understanding the dead lock with examples. I really enjoyed and clearly understood what a dead lock...