Try looking at this page and passing more information... It is difficult to know what someone is getting and what they want to retrieve without some data, code, etc....

Nice solution! 

DECLARE @nstuResults TABLE( Key_ varchar(25),

                                                  Rank integer,

                                                  Data varchar(10))

INSERT INTO @nstuResults

SELECT '123456-Sub_ID-Exam_Name', 1, '330'

UNION ALL

SELECT '123456-Sub_ID-Exam_Name', 5, '3'

UNION ALL

SELECT '123456-Sub_ID-Exam_Name',...

I think that will still return a "datetime" value.  Look it up in BOL.  (It returned the 12:00:00 AM value in my Query Analyzer)

It should work as long as the table is full-text indexed. 

Try the following for @inputParm on a table that you can blow away...

SET @inputpart = '; DROP TABLE...

How will you accomplish this without parameters passed in?

Curses & Blessings of Dynamic SQL

I would vote to just drop it... 

If I am understanding you correctly, you have a column in one table that is varchar with a date only as the entry; I do not know any other datatype which...

Can you elaborate?  Your two choices: smalldatetime and datetime will yield "time".  Are you using this value in a select statement or passing it to another database or a front-end...

DECLARE @Value AS datetime

SET @Value = '11/20/2006'

SELECT @Value

SELECT CONVERT( varchar, @Value, 101)

Try this: SELECT CONVERT( varchar, GETDATE() , 101) 

You can change the 101 to any other number of formats to fit your need...

Although I personally agree with Sergiy, this is interesting fodder for thought.

Clean up is always a consideration, but it does vary with each platform. Fourth generation applications are insidious...

You betcha! Nice to be thanked.

I think this link is goofed up. Here is a better one...

Identify Primary Key Violation Prior to Insert (Updated) script by kgayda ...

I did not even see that I forgot a table after...

Doh!  I am seeing the utility of both points; especially if you are using a Connected Dataset as opposed to a disconnected.  It seems you would have to build another...

This is an "as the crow flies" approach.  If you are using streets between stores within a given area, (i.e., from one location within a town to another location within...