Hello,

This is the exact solution you are looking for.

Check out: T-SQL Split UDF function by delimiter

Here is one line solution in my implementation.

http://praveenbattula.blogspot.com/2009/04/how-to-know-month-name-from-month-index.html

Here in this post there is one single line solutions present.

http://praveenbattula.blogspot.com/2009/04/knowing-number-of-days-in-month-in-t.html

Here is a simple one line solution which does the trick.

http://praveenbattula.blogspot.com/2009/04/knowing-number-of-days-in-month-in-t.html

Sorry, didn't look at your second post. That was my mistake. Please don't consider it.

thanks

Here is the simple solution which is of one line.

http://praveenbattula.blogspot.com/2009/04/knowing-number-of-days-in-month-in-t.html

See this small example and check that helps.

http://praveenbattula.blogspot.com/2009/05/how-to-generate-random-numbers-in-t-sql.html

Here is the solution you are looking for you,

http://sqlserver.ro/blogs/cristians_blog/archive/2007/11/20/turning-off-intellisense-in-sql-server-2008-ctp5.aspx

Here is the solution you are looking for you.

http://sqlserver.ro/blogs/cristians_blog/archive/2007/11/20/turning-off-intellisense-in-sql-server-2008-ctp5.aspx

It should work. Try to change the correct database name on the drop down [More left corner in Management studio] and then follow this process.

http://praveenbattula.blogspot.com/2010/01/refresh-intellisense-local-cache-in-sql.html

It is on May 12, 2010

http://praveenbattula.blogspot.com/2010/03/sharepoint-2010-release-date-announced.html

Try this one. May helps.

http://praveenbattula.blogspot.com/2010/01/date-formatting-in-sql-server-reporting.html