You have a stray '-' on line 11 (ish) of your script where you set the userName var

Orlando Colamatteo (1/13/2016)

---

sushantkatte (1/13/2016)

---

I want to select getdate() in the format yyyy/M. i tried to write a query as SELECT FORMAT(GETDATE(),'yyyy/M') but it is giving me error.I am a beginner...

Some issues with your HTML template:

i. The head tag is inside the table tag, try moving it (and the style tag it contains) to before the H3 tag

ii. The...

mistylove98 (4/23/2015)

---

Thanks all for the help I feel kinda stupid now. Yes it should not have been shipped date it should have been

delete LMOrders where OrderDate between 10-10-1996...

You don't need to do both

cmd.ExecuteScalar())

and

cmd.ExecuteNonQuery()

You're executing the same query twice, the 'ExecuteNonQuery' is...

If I understand your question then this should suffice

SELECT TOP 1

*

FROM

DutyRosterShiftHisto

...

DavidBridgeTechnology.com (1/9/2013)

---

Whilst others are being picky I thought I would add my bit.

None of the answers are right

When is New Years Eve anyway?

If its January 9th (as it is today)...

sknox (1/4/2013)

---

The only problem with that is, since...

Thanks Steve for the question.

Thought I'd throw this in just for fun. Should work for every day of the year:

SELECT DATEADD(DAY, -DATEPART(dayofyear,GETDATE()),GETDATE())

Try

SELECT ASCII('€');

Jonathan,

I think you may have cracked it there, I suspected mine was too complicated.

With one slight modification to your where clause to account for different DATEFIRST settings:

WHERE

...