Nevyn (7/26/2010)

---

The way "money" and thus "isnumeric" handles commas seems to be fairly dumb, though. Instead of validating commas in only certain placements, I guess they decided to just...

Then VARCHAR. Give it some relevant size based on sample of data you have. It looks like extract from other system, so you may ask for specification describing maximum length...

How are you going to name this column?

If it's Comments then varchar can be used.

If it's intended be "Details", then follow Gail advise and split it into separate columns,...

I think that regardless of settings such comma separated string in SQL can be easely converted to money:

select CAST ('100,200' as money)

returns 100200.00 !

and

select CAST ('100,200,300' as money)

returns 100200300.00

And...

Jeff Moden (7/26/2010)

---

Ok.... you have 100...

Ok, I may be an idiot. BUT!

Did anyone, before providing answers, understood what this OP really have in his DB and what he is really trying to do?

He said that...

try:

declare @date datetime, @freq int

set @date = '2010-01-29'

set @freq = 6

SELECT DATEADD(MONTH, MM, @date) AS ReqDate

FROM (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - 1 AS MM FROM sys.columns) TallyOnFly

WHERE...

I wonder, for

select 5, 'ABC', 2002, 27 union all

select 6, 'ABC', 2005, 27

Do...

tasnim.siddiqi (7/26/2010)

---

Hi,

I have also run your code, with the Output Clause. I get the following error

Msg 4104, Level 16, State 1, Procedure stored_proc2, Line 50

The multi-part identifier "Temp_Event_Import.Cert_Status" could not...

1. Noodles are greate for asian cuisin but not for T-SQL :-D, therefore first step will be transforming your statement into readable form (please note how using table aliases and...

OLAP? - Even better! :w00t:

You can start learning...

If the task you are implementing going to be regulary executed, I would suggest using SSIS, as it is specifically designed to do so.

BCP will be the fasterst method to...

There is...

malleswarareddy_m (7/22/2010)

---

I know that but some one of friend told that its take more time to execute.that why i posted if there is another way which executing faster than using...

Friend, when I have read your question first time I thought that you are drunk 😀

After looking it closely I think now I understand what you want.

Assuming that the grouping...