Hi Guru,

Could you specify more detail? I don't see the SQLDebugger account in my machine.

Hi noeld, your sql comes up 22:59:59 which is obviously incorrect.

Slightly change here:

select convert( varchar(8), @d2 - @d1, 8)

SQLBill, your sql also comes out an incorrect answer:2:12:1

This is what I...

I am using system sp to get sort of recordset, and then I need to combine this recordset within other select statement. I doubt if I can do this using...

Hi PW, thanks for sharing your code.

My tool is used to retrieve info from any database, so I can't assume the size of objects, that makes me have to...

Hi RGR'Us,

Thanks for your help. I actually have found a bug of my own code, I am sorry about this posting. Thank you very much.

Hi RGR'Us, thank you for your reply, here is my front end code to concatenate the splitted records.

Public Function MergeDataSet(ByVal...

I understand there is a 4000 limitation in text column of syscomments, in my script, actually more than one records are returned, which means the script has been splitted to different...

I think you didn't notice my requirement: no cursor or temp table is allowed here.

Thanks.

While I am sorting this out by doing something external work, I believe there should be a simple and better internal solution.

Thanks.

Yes, those docs will still be neccesary for people to download, so they will be stored in database too.

Thanks for your quick response.

Do you know what's the scanned and OCRed file type I can get? a word .doc? Then I save this file as an image object into...

Thank you guys. I still have question: why the revised query returns incorrect size for nchar and nvarchar? e.g. in Northwind, the CompanyName is nvarcahr(40), this script will return 80,...