What´s the problem with the code I posted?

Maybe something like this:

SELECT *,

DATEADD(HH, DATEDIFF(HH, '2017', TestDate), '2017') PartitionUsed,

DENSE_RANK() OVER(ORDER BY DATEADD(HH, DATEDIFF(HH, '2017', TestDate), '2017')) RN

FROM @Sample;

2008 and 2008R2 are two different products. Each of them have different releases and version numbers. They're very similar, but are different enough not to have been considered a Service...

How about making this a persisted computed column using a UDF?

Served

drew.allen (1/9/2017)

---

CELKO (1/7/2017)

---

The check constraint can be used by the optimizer immediately;...

I usually avoid APPLY with correlated suubqueries because it tends to run the query row by row. Obviously, this is a general...

mishrakanchan86 (1/9/2017)

---

Hi ALl

I have a view which looks something like below.

Select

* from T1 with(NoLock)

Inner Hash Join T2 With (NoLck) on T1.PID = T2.PID

Inner Hash Join...

Jeff Moden (1/9/2017)

---

You just have to wonder what was on the mind of the...

Why do you want to use one specific version? Both can connect to any version.

If possible, you should remove those SSMS versions and install SSMS 16.5 which is the latest...

Something like this?

SELECT

pr.Title AS ProjectRoot , pr.ID AS ParentID,

wf.Title AS WorkFlow , wf.ID AS WorkflowID,

...

Here's an option that you might want to consider. First, it removes unnecessary characters and changes the delimiters into something that shouldn't be part of your string. Then it uses...

anjaliagarwal5 (1/5/2017)

---

Hi All,

I am trying to create a local Instance. When I issue a command ssms.exe from the below directory. It always starts SQL server 2008 which is also installed...

mikevessey (1/5/2017)

---

why not use a TABLE VALUE PARAMETER in your stored proc

simply use the CREATE TYPE statement (to create a table type), then create your proc using the table type...

I agree with Sue. You should do all this through T-SQL. If you prefer, you can use the GUI to build the code and use the bottom in the top...