glad it's helping you out Vincent;

you know that's a neat idea and exactly why i love SSC; other peoples feedback make everything better.

Sometimes you cannot see the tree when you...

this thread is a follow up to ny66's need to parse a substring into seperate fields:

http://www.sqlservercentral.com/Forums/FindPost967451.aspx

in that post, I had assumed the data was single-space delimited, based on the example...

steve i think all you need to do is instead of getting the max(probability), you just createa a subquery with a group by construc, and join to that;

based on your...

ny66 (8/17/2010)

---

if i use replace, i still cant get the values in the columns i need due to length of the field. there is no set length on the first...

i think your developers are right, and that the order of joins has no meaning; as I understand it, no matter the order of the joins, the Query Engine will...

OK i'm not sure why you cannot use the existing GUI tools in SSMS to script the table, including the index definitions; in 2008 you can also get the GUI...

I believe the procedure will fail, because only an existing sysadmin can create another sysadmin.

so even though your UserA is db_owner in his database,

as long as his personal logon is...

sgambale (8/17/2010)

---

Thanks for the replies. It makes sense that 1, 2, or 3 blanks is treated the same (with the entire column filled with blanks), but the empty string...

if you used the GUI, you can rename a stored procedure without having changed it's underlying definition. that was at least true in SQL 2000 with Enterpise Manager.

so i could...

that is...

the LEN() function ignores trailing spaces, even on a CHAR data type, where the DATALENGTH() function respects the spaces;

so to find exactly two trailing spaces in a column:

SELECT * FROM...

you cannot modify the built in roles in any way;

what you want to do is...

ok i'm pretty sure you are pasting untested code, because the tables you pasted do not have the same column names as the trigger;

i'm not surprised nothing seems to work...the...

well, the way i read your trigger, it should be working just fine.

if you run this commnad, do you see changes in the status?

SELECT i.AppointmentUID,i.AppointmentStatusUID,StatusStartTime

FROM AppointmentStatusTransactions

GROUP BY i.AppointmentUID,i.AppointmentStatusUID,StatusStartTime

...

the UPDATE() function is so misleading.

the UPDATE() tests to see if the column name was specifically included/named in the update or not...it does not test if a value changed.

what...