Mmmmm coffee 😀

Grant Fritchey (9/30/2010)

---

It depends on the data. Based on the stuff you provided, '0x4C8A2BCB' is absolutely not an integer, a whole number without decimal points, which is what the int...

Hugo Kornelis (9/27/2010)

---

tommyh (9/27/2010)

---

I dont agree with your arguments either. A string is either a number or its not. Not depending on what you try and convert it to. It...

Hugo Kornelis (9/27/2010)

---

tommyh (9/27/2010)

---

da-zero (9/27/2010)

---

Good question, although I seem to remember that I've seen similar ones.

But I don't think that considering scientific notation as numeric is stupid. 2e1 is just...

Toreador (9/27/2010)

---

tommyh (9/27/2010)

---

True but atleast 1 and 1 are both numeric both in and out off context. Wheras "e" is only valid under some circumstances. With "11" you can do...

da-zero (9/27/2010)

---

tommyh (9/27/2010)

---

da-zero (9/27/2010)

---

Good question, although I seem to remember that I've seen similar ones.

But I don't think that considering scientific notation as numeric is stupid. 2e1 is just another...

da-zero (9/27/2010)

---

Good question, although I seem to remember that I've seen similar ones.

But I don't think that considering scientific notation as numeric is stupid. 2e1 is just another way writing...

<rant>

Yeah... like total crap. Its borderline useless. Just to further demonstrate that.

select isnumeric('2e1')

This gives...

sathish.tbj (9/24/2010)

---

Tommy,

I apologize for cross posting.

Can you please explain me about this particular area of a solution? I like to know the process.

--------------------------------------------------------------------------------------

DECLARE @XML XML;

SELECT @XML = '<r>'+REPLACE(@Code_String, ',',...

Crossposting = bad.

Discussion about this can be found here as well

http://www.sqlservercentral.com/Forums/Topic992468-338-1.aspx

Rune Bivrin (9/24/2010)

---

Toreador (9/24/2010)

---

Rune Bivrin (9/24/2010)

---

However, looking the table in the question I'd probably remove the NULL-ability on the cell phone numbers. Nullable VARCHAR often doesn't make sense. Particularly when...

sathish.tbj (9/24/2010)

---

Hi

ALTER function [dbo].[GetEloquaColumn]

(@Code_String varchar(200)) returns varchar(300)

Here the value passed looks like [dbo].[GetEloquaColumn] ('HC01,HC02')

as

begin

declare @code varchar(200)

set @code =replace(@Code_String,',',''',''')

set @code=''''+@code+''''

DECLARE @CodeList varchar(250)...

Have to agree with UMG Developer. The "Multiple identifier columns" shouldnt be part of the answer for 2 reasons.

1. Its not part of MS recommendations (atleast not on the page...

Well as far as i know there is no way off doing this. A maybe acceptable solution would be to search all "normal" string column (char/varchar and unicode version).

However...

p0peye (9/23/2010)

---

Please correct me if i am wrong...

My understanding is, you wont be able to commit or rollback inner transaction separately as the outer transaction will override with its commit/rollback...