Select Count(Names),MemberId,Names from Table_Sample group by MemberID Having Count(Names)>1

May be credentials issue..Plz chcek which account you have used ?

Add one more Script task or executeprocess task (Batch file) to test whether the server is able to access...

Yes,

Truncate will remove data from Table and reset/initialize the identity value.

Use Joins correctly...

Stewart "Arturius" Campbell,Thanks for your comments..

There are some typo in Explanation , plz understand yourself :-P.

Here you can go how to use DELETE OPEN QUERY...at the end .

https://msdn.microsoft.com/en-IN/library/ms188427.aspx

There is no script..

If your database was containing relationships like Parent and child ,

Database Diagram option from SSMS will give you complete picture for selected Objects. If there is no...

Please post your modified Query...

I thought you have applied for one column only...

Do this expression at the backend Proc or SQL Query and show it as in String in front end..?

DECLARE @i INT

Select @i=33059

Select CASE WHEN LEN (@i)=5 THEN '0'+LEFT(CAST(@i as VARCHAR(2)),1)+':'+SUBSTRING(CAST(@i as VARCHAR(2)),2,2)+':'+RIGHT(CAST(@i as VARCHAR(2)),2)

WHEN LEN (@i)=6 THEN LEFT(CAST(@i as VARCHAR(2)),2)+':'+SUBSTRING(CAST(@i as VARCHAR(2)),2,2)+':'+RIGHT(CAST(@i as VARCHAR(2)),2) END

OR

DECLARE @i INT,@var...

You can use FileStream concepts here...

However when you want to open specific file , add with file name type like .wav or .txt or .jpeg etc...

I got similar requirement for...

You said that DeliveryNote is poulated from SDN's ID...

So, there are no records in SDN which are not in SI.

Use the following query for your test,

select SDN.id, SDN.number ,SI.DELIVERYNOTE

from...

Please give the information whet you required in detail..which will help to give Correct one...

I think below one is you required..

Use group by for Id Column of Derived table ...

The total records are of 10-25 Millions...