Does the trick, thank you. Oddly enough I was using collate on another column when using charindex for another field and must have just thought replace was different.

The function does work with embedded line feeds but the problem is with the first character being a quote (") and also tossed in the empty quoted string for good...

I've hit similar issues with holidays rolling and so far up to 7 different types

I also came across an issue with datefirst and should really be noted. Besides...

GilaMonster (1/21/2010)

---

Aren't the differences what you'd expect?

With an inner join there must be a match in the second table, so the only rows that can appear in the resultset will...

The application is using a particular user but is also using that user for TableA ins/upd so TableB wouldn't be updated by the trigger on TableA.

I have TableA which is transactional. TableB is basically a roll-up(sum of data and additional data) of TableA. Currently the application is inserting/updating both TableA and TableB. It is beyond...

Interestingly enough, I truncated the table, rebuilt statistics for everything and the estimated execution plan is in fact the nested loop. However during execution it reverts back to the merge....

I've also been doing a lot of scripting to generate procedures, tables, etc... I tweaked my process to accomplish the same task here. I really haven't tested it too much...

I couldn't get it to work without a minor tweak.

I changed the following snippets...

SELECT @ConctColNme = CASE WHEN @IdentityColumn = @ColumnName

THEN ''

ELSE @ConctColNme + @ColumnName + ','

END

SELECT...

I've been working on similar issues including reproducing creating table and missing columns and thought this would help a lot. It does, thank you. However there are some clitches in...

Thank you all and as you all stated, I'm the next in line to maintaining this :w00t: so I will clean it up and see if there are any performance...

Thank you very much, that's what I was looking for. I'm not worried about indexes because we do name them and not sure if you can make an index without...

Didn't seem to work. Both versions have is_ms_shipped = 0

IF OBJECT_ID('tbl') IS NOT NULL

DROP TABLE tbl

GO

CREATE TABLE tbl( id INT NOT NULL)

GO

ALTER TABLE tbl ADD PRIMARY KEY(id)

GO

SELECT * FROM sys.objects...

Yes, should have thought about the column value being null. :hehe: From my perspective of searching, at least with our application, we are always looking for a value and most...

I was having a lot of trouble with this one myself and actually found an answer on Oracle and changed it to SQL Server. I also found that SQL Server...