crux1187 (10/5/2012)

---

I am wondering if there is a way to overwrite or customize the system error thrown by SQL server. For example error message 521,instead of the default message you...

54.69.6d.20 (10/5/2012)

---

I just setup a new Win2011 64bit SBS server which is now hosting our website (Was on an old 2003 server, where 2008 SQL was hosted on too). Some...

Your google-fu is just failing you today. Try searching "code snippet storage". You will find lots of apps for doing just that.

parth83.rawal (10/4/2012)

---

Hi,

I am using FOR XML to generate the HTML and following is my query. i want to apply class in td, how can i achieve the same ??

CAST (...

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.