Always trying my best! 😀

Actually I have a version of compiled machine code for this. It goes something like:

010001011110100101110111100001110001101110110101011011101001

010101011101101010101110110011101110111101111011110111111011

110110110111101111011000110110101101110111110111011010111011

etc. (It actually few thousand pages, but I can attach the...

Call Microsoft and ask them to send you copy of SQL Server source code. Be nice with them and I'm sure they will help you... :hehe:

Can you post ddl for your procedure

Nothing!

But it is recommended to use varchar(max), nvarchar(max) and varbinary(max) instead.

You have placed '2012-04-29 08:30:00','SOME TEXT' into your expected results, but it is present in #tableTwo?

What it makes to be picked up for the result?

Is it just because...

khushbu (4/24/2012)

---

From BOL: http://msdn.microsoft.com/en-us/library/ms186939.aspx

nvarchar [ ( n | max ) ]

Variable-length Unicode string data. n defines the...

where +2 coming from?

Yeah, but you can simply multiply varchar column sizes by two, as it will give you much larger number than it will really take.

Saying that current column varchar(100), changing it...

Are you looking for Auditing solution?

Depends on the depth of details you want to trace, there are few methods and most common are:

- custom auditing using light-weight audit triggers (still...

Yes it is possible:

SELECT * FROM Table WHERE Column = Column OR Column IS NULL

I'm sure you...

I love threads from this OP, they make my day!

They are example of horror, drama and comedy in one!

a la Alfred Hitchcock

You most likely do not need to use loop.

Please follow the link at the bottom of my signature to find out what we need to help you.

Go low-tech:

Use three PC's or non-permanent marker.

Charmer (4/23/2012)

---

My cursor is taking...

maryamzolfaghar (4/23/2012)

---

sqlcmd -S servername\instanceName -i inputfile -o outputfile

inputfile contains the sql query

outputfile: The output goes here, but the results tab output and messages pad are both included

I need the...