So you want to find out which user really issued the CREATE TABLE command, regardless of any subsequent changes (e.g. via sp_changeobjectowner)?

Sorry, I have no idea how to do that...

Mark's solution is OK if you need to convert the date to VARCHAR anyway. If you want to keep it as DATETIME, just strip away the time portion, this is...

View will not change anything.

As I understand, you only need to use ID and name of the journal in these complex select queries. Since these will change very rarely (as...

Just tested something... CRLF should be enough if you are exporting into a text file with fixed length:

Don't do any views dividing the lines into "first" and "second". Simply put...

Hi,

unfortunately you didn't supply table definition and data, just result, so I had to do some guessing.. but I think I got it.

--Test data

CREATE TABLE #export(doctype char(20),docname char(20), phone char(18),...

I was working with one table, too, in my example. Hmmm.. well, do you mean that you want to mark with 1 only those rows that have max sequence number?...

If I understand it right, you have 2 tables - one has a row for each second, one has 1 row every few seconds. If there is no row in...

Please explain in words what the update should do. I don't understand what is your requirement.

If you simply want to set column ind to '1' in all rows (according...

Just a wild shot... any chance that the data is VARCHAR (or is converted to it at some moment during the export)? That would explain missing trailing blanks.

You can use ORDER...

OK, thanks, it is more clear now. It is kind of a logging of how often and with which parameters certain SP runs.

No trigger, the insert must be part of...

I'm afraid you'll have to be more precise if you want to get some useful information...

What does the "one stored procedure"? What tables are used? On which table will be the trigger?

Also,...

Actually, there is one CASE too much in your SQL (probably just a typo):

CASE WHEN col1 = 1 THEN 'yes'

case  WHEN col2 = 1 THEN 'no' 

        ELSE 'maybe'

END

Hi,

a few pointers...

- ISNUMERIC does not check for "numbers only" properly. Certain values are considered numeric, althought they contain letters and other signs (like +, - and a few more)....

UDF needs one value as a parameter. (SELECT  PositionID FROM Employee WHERE  ID = 5) can give a resultset that has several rows. However, this should cause "Subquery returned more than 1...

Please read at least a short section about datatypes in BOL. You will find out that MONEY datatype has no parameters that would...