GETDATE() is just a function that returns today's date, as an example datetime.

You would substitute your date column names

SELECT CAST(CONVERT(VARCHAR(10), StartDate, 120) + ' 12:00:00' AS DATETIME)

If you only need...

The standard way of doing these casts is to go via varchar and back to datetime, truncating any data not required

e.g.

SELECT CONVERT(VARCHAR(10), GETDATE(), 120) -- get date as...

Yes dynamic SQL would seem appropriate.

Basically you create your entire SQL Statement in a string then call EXEC on it.

e.g.

DECLARE @sql Varchar(MAX);

DECLARE @TODAY Varchar(10);

SELECT @TODAY = CONVERT( VARCHAR(10),GETDATE(),...

I'm sure there would be a way of passing the required dates as a variable to the stored procedures., or, if it is always the current date, why not...

First time I've looked at one of these puzzles. Managed to tie up my cpu for ages generating useless batches of permutations and combinations. No result yet. ...

Thanks: very useful information. 🙂

SELECT a column from your table, then put it into the @Variable in the FETCH Statement.

Here is a full example.

CREATE TABLE #Tmp (

i INT IDENTITY(1,1),

val VARCHAR(50) );

INSERT INTO #Tmp (val)

SELECT...

Depends what you need.

#Temporary tables can only be accessed by the instance of stored procedure that is running. If two instances of the stored proc are running they each...

Be aware that cursors are not always the best way of doing things.

Here is the standard cursor code. Promise not to abuse it 😉

DECLARE @i INT;

DECLARE @COUNT...

I got it right only because I was expecting a trick question. 😀

UNIQUE is optional, so omit that if empno has duplicates.

But if empno has duplication, then isn't it a complete duplicate row (same firstname/middlename/lastname too)

BeginnerBug (9/13/2012)

---

Thanks Brown!!!.. but i cant make column empno as autoincreament as per requirement....but i can additionally add one more column and make it auto increment. will that avoid table...

Yes you can create a clustered index on a #Tmp table.

The syntax is exactly the same as for a normal table.

CREATE [UNIQUE] CLUSTERED INDEX CIX_Tmp_EmpNo ON #emp(empno)

Since empno is used...

See CAST AND CONVERT http://msdn.microsoft.com/en-us/library/ms187928(v=sql.105).aspx

There are loads of date formats available, though you may have to truncate the time portion.

You need something like

SELECT CONVERT(e.expiration_date, varchar(11), 130) AS Expiration_Date;

Ali Tailor (2/17/2011)

---

Hi all;

I just passed the MCTS exam 70-432 with 833 marks, I just want to Know that may I use the MCTS Logo on Resume if yes, in...