Glad to help, we've all been there. SQL Server is an interesting topic to be sure!

You can access the various convert options on "books on line" in SQL Studio by searching for 'convert', and you can see that you do have some options for formatting...

I've always accepted that all the tasks we want our digital machines to do are going to vary in the methodologies best used to implement them. I'm also hopefull that...

My take! Obviously that means the 0's will end up being date 1900/01/01 and I guess you could substitute that with NULL or otherwise acceptable value. Apologies if some of...

anthony.green (11/15/2012)

---

GilaMonster (11/15/2012)

---

This.

A backup that starts at 10:30 and finishes at...

uttar (11/13/2012)

---

Hi,

I want to find the average in my text box.i have my code(conversion) in my report properties(custom code) where i calculate my years,months and days.im my database i have...

Matthew Cushing (10/16/2012)

---

Okay, so I've discovered that if I remove the initial parameter that I had looking for a date, and hard code it in my sql for dataset1, then...

may or may not be an...

Here's a good page for some nice hints on dealing with unicode:

http://msdn.microsoft.com/en-us/library/ms180059.aspx

GSquared (10/31/2012)

---

Theoretically, if I am ever asked that kind of question, I'd be inclined to answer something like, "I know there is an upper limit, but a properly normalized database...

instead of the colon (:) try a comma before the port number.

mkarthikeyyan 89837 (11/1/2012)

---

I have character or symbol in my column like "?". Please help me to find out the rows which are all having this("?") character.

My column value: Digital ?...

PiMané (10/31/2012)

---

Well.. when someone like Gail says "No. Just...

PiMané (10/31/2012)

---

Hi,

Just tried the sys.dm_sql_referenced_entities but the dynamic SQL isn't analyzed...

The following code returns info for the "normal" GetProducts that uses ProductId = COALESCE(@ID, ProductId) AND ... but as you...

guerillaunit (10/29/2012)

---

Perry's solution didn't work either. It fixed the error, but the function just returned the input. I ended up concocting a custom function to do the job....