$w@t (6/12/2013)

---

After Posting my question only I have seen that solution...

I am not going to use it anywhere..I faced this Question in interview..so i posted here

I Just want to...

Why did you ask this question, when you already believed you knew the answer?

Would you consider implementing the method shown...

Please explain what...

There is an alternative way of doing this - you might like to check to see whether it performs any better:

with maxJournal

as (

select ClientId

,JournalId = MIN(JournalId)

from Journal

group by ClientId

)

select *

from...

mrtrich99 (6/11/2013)

---

I have not. I just manually rename the...

sarah.cook (6/6/2013)

---

Hi,

I need to create an id from a nvarchar value that is repeatable, sort of like a checksum or a hash, except that it needs to be unique...

I would add an OUTPUT clause to your DELETE query. Have a look at the examples here.

No problem and thanks for posting back.

You could try something like this:

delete a

from TableA a

where exists ( select 1

...

Here is the code for a script task to check for the existence of c:\temp1. If it does not exist, it is created.

public void Main()

{

string folderCheck...

Hello

You will find that you will get a much better response if you take the time to post your sample data and desired results in the form of readily...

How does the NULL appear in the flat file? Presumably one of

,"",

,,

,NULL,

eylenh (6/11/2013)

---

about the StreamReaders : I inherited this project and apparently they are used here because the import is done using SqlBulkCopy which should be faster than a dataflow component...

The StreamReader.Close() command calls the Dispose() command, passing a value of true (the Using() construct does the same thing). I have tried calling Dispose() and while it executed successfully it...

homebrew01 (6/10/2013)

---

Good question .... not part of a solution that I know of .... (But I am part of the problem it seems

Do I need to save it as part...