Easy one compared to yesterday QOTD. yesterday i got it wrong. i did not verify verify between operation -1 and -10.

Raghavendra Mudugal (5/14/2013)

---

Really Good one, Hugo, thank you for posting (so basic and so much of valuable point)

(Not sure and can't think of why one would use as "BETWEEN -1...

Even though i know the answer i got it wrong . I got confused with question

nenad-zivkovic (5/9/2013)

---

Toreador (5/9/2013)

---

A good question, but I'm not so sure about the explanation.

If a column is referenced in a subquery that does not exist in the table referenced by the...

I faced this issue when coding for my project work. We follow naming conventions and we use '_' for oltp tables. Before doing the functional testing I usually test...

Nice question. Thanks for author for submitting. Please keep posting this type of good questions.

Simple and an Easy one

+1

Because Id value 4 is not exits in t2 table. Thats why you getting error.

If you have foreign key then the reference column value must exists in parent table.

below...

Same thing happened for me also

Easy Question

hey am not expert in ssis.but i think you need to put equal for CONNECTION ="MySecond.Connection.String";

http://msdn.microsoft.com/en-us/library/ms175997.aspx

It will show in white color when your service getting started.wait for some time. if still it is showing in white color right click on instance and restart the instance

You can use multiple ctes like this

create table #temp (ID int, Name varchar(20))

insert into #temp

values

(10, 'Helen'),

(20, 'Joe'),

(30, 'Blake');

;with cte as

(select * from #temp)

,

cte1 as

(

select * from #temp

union all

select...