This might work for you

SELECT CONVERT(VARCHAR(8),GETDATE()-1,112)

Result:

20111023

Have you read the entry in Books On Line (SQL help file) for the item

sp_executesql (Transact-SQL) It has multiple examples of T-SQL code to accomplish what I think...

Suggest you start your search by reading this:

http://msdn.microsoft.com/en-us/library/ms190639(v=SQL.100).aspx

and then read: (Written by Brad McGehee)

http://www.sql-server-performance.com/2007/clustered-indexes/

Read this article

http://sqlblog.com/blogs/kalen_delaney/archive/2007/11/21/cloning-in-sql-server-2005.aspx

It contains detailed step by step instructions on how to do what you want to do

A couple of questions.

1. Does the input and text boxes have INPUT MASKS associated with them? If yes are they configured the same?

2. Does the SP...

Nice question

sqlguy-736318 (10/22/2011)

---

Thanks Ninja - I assumed that table variables would always have better performance than temp tables but based on your emphatic NOOOO it sounds like you have a lot...

sqlguy-736318 (10/22/2011)

---

Thanks Ninja - I assumed that table variables would always have better performance than temp tables but based on your emphatic NOOOO it sounds like you have a lot...

sqlguy-736318 (10/21/2011)

---

Do you use a CreateTempTable function to create temp tables in your T/SQL?

Basically when you create a temp table as part of a T/SQL script you have to first...

Keep in mind that UNIX and DOS do NOT use the same characters for end of line and end of file.

This might help

http://www.brandonhutchinson.com/DOS_and_UNIX_end-of-line_characters.html

kstjacques (10/21/2011)

---

I need some opinions here.

I am using a backup solution (will remain nameless) that fails if a tlog backup is triggered during a full or a diff. This...

Nice question

Enough said

If this is not a home work assignment, my fee for supplying what you requested is 60.00 U.S. Dollars, with a minimum of $300.00. If it is a homework...

To prepare for moving to 2008 may I suggest you read up on the MERGE statement to determine if it will satisfy your requiements.

http://technet.microsoft.com/en-us/library/bb510625.aspx