mick burden (1/20/2012)

---

both examples look good to me, is there a way of making that dynamic? the amount of names are 10 in number at present and although that could...

If at all possible you should normalize that table. You don't want to have columns for each person. You should probably have two tables for this. One table is your...

Sounds like you need to investigate triggers. It is very hard to understand exactly what you are trying to accomplish but it sounds like an update trigger on your validation...

Nice straight forward question with a nod to Carl Sagan. Great ending to the week and "keep looking up". 😀

This is one of the challenges of the way your tables are designed. You are using a table as a catch all. In other words the table holds multiple types...

I agree with one small caveat. If we got rid...

It is very unclear what you are trying to do here. Perhaps if you posted some ddl (create table statements), sample data (insert statements) and a clear explanation of what...

roryp 96873 (1/19/2012)

---

I guess my only complaint is that you would have a problem if the text string was longer than 2048 characters. I suppose that could be fixed...

Agreed. That is pretty slick Mark. I was going to use Moden's splitter...

select * from

dbo.DelimitedSplit8K('2:42 1/29 On R.P.C resolved vendor was instructed on Friday failed to send 2020817 813 811...

It is most likely due to differences in dateformat. run DBCC USEROPTIONS on both servers and the dateformat is likely different.

declare @MyMoney money = 206960.8333

select CEILING(@MyMoney) --Always round up to next dollar

, FLOOR(@MyMoney) --Rounds down to next dollar

, ROUND(@MyMoney, 0) --Round but keep as money type with decimals

, CONVERT(int, @MyMoney)...

That is where the "Top 1" will come in handy.

cross apply (select top 1 date from table order by DateCol desc)

drew.allen (1/18/2012)

---

Sean Lange (1/18/2012)

---

I would ask though why do you need more than 1 column that is unique? The point of a unique index is to allow you to identify...

bteraberry (1/18/2012)

---

Sean Lange (1/18/2012)

---

I second the opinion of not doing dynamic sql like this. Your whole query is only a single simple select statement. Even if this is "internal" only...

Maybe I am misreading the OP but there was never any mention of anything other than inserts. Either way the OP has figured out the solution. 😀