and for you request, look at Example B in the link i provided...

Excerpts from MSDN link

B. Using a DML trigger with a reminder e-mail message

The following example sends an e-mail...

Hi there..did u try TRIGGERS?

Probably there is a straight-forward way, but this is what i have come up with :

select replace(cast ( convert(decimal(25,2),25.00) as varchar) , '.' , ',') Comma_Value

dint this work?

select cast( 25.000000 as decimal(25,2))

DEXTER !! he is not a Super Hero technically or physically but mentally, he is the HERO of the SUPER Lab 🙂 awesome innovations, awesome inventions, he really is a...

It happens, Tom.. More than the order at the GROUP BY clause, you perhaps needed some more coffee 😀

Dint SUM and GROUP BY help ?

Like ?

selelct invoicenumber, invoicedate, sum(invoice) invoicetotal

from table

group by invoicenumber, invoicedate

GETDATE wont remain constant even if it is in a loop... if you want to maintain that as constant, store it in a varibale before the loop and then...

Quatrei.X (8/27/2010)

---

Question 1:

Use tally table or CTE... which is a better practice? (although I'm already thinking of CTE but still wanna hear from you guys)

Jeff Moden's CTE in his dbo.DelimitedSplit8K

WITH

...

Welcome, Min!

scottichrosaviakosmos (8/26/2010)

---

sorry i got it.

but slight issue, actually i m displaying this value in an application so i want all null valued columns to be displayed in a different...

Karl, did u check the solution posted above your post?

FRO XML , can be used like this:

declare @tab table

( id int, remark varchar(100))

insert into @tab

select id, remark from

( select...

We can do it using FOR XML...

Please go through this following article and helping us help you??

CLICK HERE FOR FORUM POSTING ETIQUETTES - BY JEFF MODEN[/url]

When u do so,...

Try this mate (replace <YourTableName> with your table name <YourIDColumn> with your rowid column )

declare @sql varchar(4000)

set @sql = ''

select @sql = @sql + '+ ISNULL((NULLIF( (ISNULL(CAST( '+ column_name+ '...