Greg,

Would you post one of your emails that has the correct format, please? Be sure to use a code window (Click on "IFCode" in the menu of the edit...

antonio.collins (2/12/2008)

---

this particular example is not a pure triangle as illustrated in your article. that's because the 'code' (account number) is used as the primary join article. so,...

Yeah, Matt... I was afraid it would be something of that nature... too bad.

Micheal, I'm right there with you... compromise is to write code to generate static code. Have...

I took a look in BOL for Kishore's suggestion on using tablediff.exe.

Lemme quote...

The tablediff command prompt utility returns detailed difference information between two tables and can even generate...

You have to create a "share" to your directory... the share would be for the user that SQL Server logs in as... OR... if SQL Server was given super user...

felipe (2/12/2008)

---

Hi Jeff,

Please corrrect if I'm making any mistake, but I think SQL creates an unique ID to each opened transaction.

If it exist, I need to get this ID number.

Thank...

You had all of that in your first post... obviously, you want some specific format and I'm tired of guessing...

Would you please type up what you want the output to...

So, what is it that you want to do? You've identified everything but that...

Instead of doing the FREEPROCCACHE thingy, which affects the whole server, just do a forced recompile in the proc. The other thing this sounds like is "Parameter Sniffing". ...

You bet... let us know how it works out... tuning queries of this nature may take one of the items I listed... or all 6. Maybe even something else......

Well.... that's why you're getting the dupes in the results... You have dupes...

...AND...

Until you figure out what made it grow that big to begin with, it's not gonna do you any good to shrink it because the same something is gonna make...

If the file width is less than or equal to 255 characters, this is a very easy way to do what you ask...

[font="Courier New"]CREATE TABLE #MyFile (LineNum INT IDENTITY(1,1), MyText...

I'm thinking a simple looping DOS batch file would work just fine... either that or maybe a simple VB script.

WHAT do you mean by "Transaction ID"? Do you mean the level of nesting within the transaction or do you mean the IDENTITY number of a row you just...