Revenant (1/21/2016)

---

ZZartin (1/21/2016)

---

Ray K (1/21/2016)

---

Luis Cazares (1/21/2016)

---

djj (1/21/2016)

---

Ed Wagner (1/21/2016)

---

crookj (1/21/2016)

---

Igor Micev (1/21/2016)

---

Ed Wagner (1/21/2016)

---

DonlSimpson (1/21/2016)

---

Igor Micev (1/21/2016)

---

Grumpy DBA (1/21/2016)

---

Ed Wagner (1/21/2016)

---

djj (1/21/2016)

---

BL0B_EATER (1/21/2016)

---

Stuart Davies (1/21/2016)

---

Ed Wagner (1/20/2016)

---

Ray K (1/20/2016)

---

djj...

Cell

AlwaysOn

I had the same situation some months ago. I think this article helped me - http://blog.sqlauthority.com/2014/11/07/sql-server-performance-counter-missing-how-to-get-them-back/

Unload and re-load the counters.

Even if you don't convert it with a style, sql server will recognize it and return the day-name from the date....

newbieuser (1/20/2016)

---

THank you. In the 1st query, does the date have to be in this specific format or is it possible to change @in_date format? BEcause the input date will...

--Example

declare @weekday varchar(10)

declare @in_date date='2016-01-20'

select @weekday=datename(weekday,@in_date)

select @weekday

or something like this

declare @weekday varchar(10)

select @weekday=datename(weekday,t.[datetime_column])

from Dual as t where t.ID = [value] -- this should be an unique id

Hi,

The message is clear: it tells you that you cannot make the update/modify so that you're violating the unique index constraint. The duplicate key value is 3601506. Such value is...

Hi

This code gives you the number of weeks:

select '11/1/2015' Date1, '2/11/2016' Date2, DATEDIFF(week,'11/1/2015','2/11/2016') [Weeks]

then you'd need something like this (maby a bit more complex code, though) to make a count...

Jeff Moden (1/14/2016)

---

Igor Micev (1/14/2016)

---

You have many options when you need to use Temp object in SQL Server:

•Table variables (DECLARE @t TABLE) are visible only to the connection that creates...

You have many options when you need to use Temp object in SQL Server:

•Table variables (DECLARE @t TABLE) are visible only to the connection that creates it, and are deleted...

You...

Good question. And if you want to lengthen the column you can do it directly without dropping the index.

J Livingston SQL (1/4/2016)

---

Wayne West (1/4/2016)

---

Steve, I'd like to see your code because I can't duplicate it. I ran the following:

DECLARE @HashThis VARCHAR(20) = 'January 1, 2016';

SELECT 'MD2' AS...

Is your query a T-SQL statement?