all the query works without any error

You could have provided the a 4th option which says that all works without any error.

confusing :hehe:

you can simply try like this

select year(getdate())- 2

and also we should make delay validation to true for the excel connection manager, correct me if i am wrong.

Good Question vk-kirov

i learned somthing about IMPLICIT_TRANSACTIONS

Hi Fiona,

it will be good to learn some vb.net and then design your front end forms,if requires any help on the sql side you can post here.

Nice Question,:-)

as you said once the condition is satisfied it will not look at other statement.

Thanks to a nice Question

I need to learn more about collations

i didn't noticed that [mobile_opt_in] is varchar(50)

You can try with the following code:

WITH messages AS

(

SELECT table_a.mobile_number,

...

it took 10 mins to go through the date functions to finally arrive at the result of 90 mins and then it is simple.

Nice article!

if it is just splitting the data based on the country then you can just use the condition split task which will split the data based on your condition (Country)....

i guess the order of processing the query will be in

1. FROM

2. ON

3. OUTER

4. WHERE

5. GROUP BY

6. CUBE | ROLLUP

7. HAVING

8. SELECT

9. DISTINCT

10 ORDER BY

11. TOP

is it depends up on...

Working on Microsoft BI also needs knowledge in SSAS and SSRS,even you require some knowledge in the programming language like VB.net and C# for some of the script tasks

even i...

i run the query in my server with 2000 as OS and sql server 2005 sp2, the result is

5781

3.33333

and in my local system it with windows XP and...