what is...

you can use the SSIS Script component to use this line of code.

Check this Link

hope it helps

so this means your CSV is multiline if im not mistaken ?

Nice question, thanks for sharing

Phil Factor (8/4/2014)

---

I'm sorry if it got scored too high, but when I ask this as part of a technical interview, it seems to stump a very large proportion of...

Nice question, surprisingly too many people still fall for it if you ask them in a interview 😀

Thanks for sharing Phil.

Following is another way of doing this

Declare @tblPersonTask Table

(

DayNmchar(3),

Personvarchar(20),

Tasksmallint

)

insert into @tblPersonTask

select 'sun', 'Jhon', 1 union all

select 'sun', 'Smith', 1 union all

select 'sun', 'Dan', 2 union all

select 'mon', 'Smith', 2...

Nice question. Thanks for sharing

i have checked it on MSSQL 2012. :crying:

ChrisM@home (7/25/2014)

---

Two remote queries - same remote server and db - are performed separately then the results from each are joined at the local server:

-- remote query

SELECT "Tbl1005"."RNC" "Col1960","Tbl1005"."RBS" "Col1961","Tbl1005"."Sector"...

can you share the complete query ? just for using the Linked Server in the query. what is the response time of the single select statement from that linked server?

prabhu.st (7/25/2014)

---

1) Ensure the file is not in open state. (in some cases, even though you close that particular file and not the excel, due to cache, you could get...

🙂

1st you cannot do it in Merge statement. However, to get a fair bit of idea what Merge can do check this[/url]

your logic is really simple. try to work...

glad to help