Instead of just telling you, how about I point you at one reference that may help you with some of what you are trying to accomplish:

http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

WayneS (3/26/2012)

---

Whew. Caught up on the last 6 weeks of The Thread. Interesting stuff going on.

It's been busy at work, hope I don't end up doing this again anytime...

Charmer (3/23/2012)

---

Lynn Pettis (3/16/2012)

---

Hi Lynn,

this is a part of my stored procedure, i use cursor here...you all say cursor is not good to be used.

Then what is the best solution...

rob_brown1734 (3/20/2012)

---

I was hoping to get some assistance with the query below. I was able to create the individual SELECT statements against the Pubs database in SQL Server 2008 R2,...

hendrianhamonangan (3/26/2012)

---

Hi Lynn,

The Detach process completed succeed without any error. The Problem is I cannot move the file on current Folder to another my prefer folder. For example the current...

It would help if you provided more detail information, not much we can do with what little you posted. What is the error you are getting, what file or...

Edit: THis may be the wrong thread for this reply. Looked like another that was started on a simalar topic. Sorry if this does not apply directly,...

Welsh Corgi (3/26/2012)

---

Lynn Pettis (3/26/2012)

---

Are you providing...

PaulB-TheOneAndOnly (3/26/2012)

---

codebyo (3/25/2012)

---

I'd really love to hear someone's opinions on why the Oracle community is somewhat difficult to find. Very different from the SQL Server community which has important events...

njdevils39 (3/26/2012)

---

capn.hector (3/26/2012)

---

njdevils39 (3/26/2012)

---

capn.hector (3/26/2012)

---

im amazed at your patience sean. im sitting here laughing. ill save you at least one time.

We need the DDL and sample data. ...

L' Eomot Inversé (3/26/2012)

---

Sean Lange (3/26/2012)

---

I've got a fun one to add to that list. Working in healthcare insurance. In the US, our Social Security Numbers are assigned for life...

I am not sure of the format when mirroring to a named instance. When I established mirroring in a production environment...

Saints

Are you providing the UserKey when executing...

Sean Lange (3/26/2012)

---

Yeah I first requested ddl and sample data for employee and employee_other in post #5 of this thread. I am now writing post #68 and still asking for...