Hey guys, I have some noob questions.

What is "fish-tank" and "flagpole" term means?

First post?

Also, excellent article!

Hi Cadavre and everyone!

Thanks for your help! I really appreciate it.

I didn't know a simple UNION approach will solve this problem. Now I know the difference between UNION and UNION...

LutzM (11/24/2011)

It's most probably not the code you're looking for, but it's a valid solution based on your sample data... You might want to...

Hello to both of you, thanks for your help.

And to clarify, yes my source table will never have overlapped values of From and To.

Thanks again!

Here is my solution:

DECLARE @TableResult TABLE(

Value1 INT

,Value2 INT

)

DECLARE @Value1 INT, @Value2 INT

DECLARE @cur CURSOR

SET @cur = CURSOR FOR

SELECT Value1, Value2 FROM Tester ORDER BY Value1 ASC

OPEN @cur

FETCH NEXT FROM @cur...

i use this:

ALTER DATABASE Northwind SET SINGLE_USER WITH ROLLBACK IMMEDIATE

EXEC sp_dboption 'Northwind', 'single user', 'FALSE'

Hi Tom, if you still having trouble, you can try my workaround it works perfectly.

I found the code (of course I modified it for my case) on other site but...

I have resolved my problem. I create custom console application to upload file to document library, and then execute it from SSIS via Execute Process Task.

But I wonder, I have...

Hi ssills, thanks for replying.

Do you know how to create (or get) UNC path from SharePoint Document Library?

Hi, thanks for replying.

That should do it. But is there any built-in function in T-SQL I can use to convert them?

Thanks again. 😀

Use SQL Profiler to trace your query.

Thanks for replying. It is good right now. 😉