Still nothing to test with but I think this might be close to what you want...

select A, b, MAX(C), MAX(D), MAX(E), MAX(F), g

from

(

SELECT distinct

BASE1.AssetID AS a

,BASE1.Name As b

,case when BASE2.AssetID...

The logic that Praveena suggested is far better than looping for this. There is no need for looping here at all. There is no reason to be concerned by the...

What you want is simply not possible using the proper datatype. I...

haiao2000 (10/4/2012)

---

raghavender.2369 (10/4/2012)

---

I agree with you, we can display the result in any desired format using convert or someother functions,

my friend said it is possible to store date in this...

raghavender.2369 (10/4/2012)

---

Thanq for your suggestion, but there is a requirement to store date in 'dd-mm-yyyy' in this format only(use only date datatype, dont use varchar), i googled about it ,...

Yes....don't use varchar. Use datetime. Then there is...

raghavender.2369 (10/4/2012)

---

I have a table(dates) with one column(Todate), I used to store date.The format of the date should be 'DD-MM-YYYY'

ex:

data stored in the table in the following format

Todate

-----------

01-02-1988

03-06-1980

select * from...

And something I have...

cphite (10/4/2012)

---

Sean Lange (10/4/2012)

---

You think it...

Randy Doub (10/4/2012)

---

Sorry, when I said fail, I meant the final result set wasn't correct, not that it logged an error. A failure with the logic.

It's updating a person's...

You're welcome. Hope my posts helped. Post back if you run into any issues or need a little help.

PiMané (10/4/2012)

---

Hi,

Is it safe to say that XML data type should be used to store data, instead of creating more columns on the table, data that won't be searched. If...

You think it didn't work or...

I agree this process sounds like it was not well designed. How do you handle things like credit card rejections or simply typing in bad info? By that point the...

You do realize this thread is 5 years...