Quick thought, looks like your SSMS is of an earlier version than the SQL Server instance.

😎

gentong.bocor (3/5/2015)

---

yes.. it's get repeated seqno now based on field1, but it's sorted by field1.

it's not...

SQLBill (3/5/2015)

---

Eirikur Eiriksson (3/5/2015)

---

SQLRNNR (3/5/2015)

---

Sean Lange (3/5/2015)

---

Sioban Krzywicki (3/5/2015)

---

Sean Lange (3/5/2015)

---

Brandie Tarvin (3/5/2015)

---

SQLRNNR (3/5/2015)

---

dwain.c (3/5/2015)

---

Is it just that it's been so long that I haven't posted one, or does the...

SQLRNNR (3/5/2015)

---

Sean Lange (3/5/2015)

---

Sioban Krzywicki (3/5/2015)

---

Sean Lange (3/5/2015)

---

Brandie Tarvin (3/5/2015)

---

SQLRNNR (3/5/2015)

---

dwain.c (3/5/2015)

---

Is it just that it's been so long that I haven't posted one, or does the Article Contribution Center...

Quick suggestion

😎

select x.*

from TableX x

join TableY y1 on y1.Y1 = x.X1

and y1.Y2 = x.X2

Quick cross-tab solution, should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_VISIT') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_VISIT;

CREATE TABLE dbo.TBL_SAMPLE_VISIT

(

SV_NAME VARCHAR(50) NOT...

As hcip.77 said there is no single correct response but this is still a very valid question, I would answer it as if it was worded slightly differently: "Your users,...

Quick note, each case statement can only output to a single column, consider this example

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_DATA TABLE

(

COL_1 INT NOT NULL

...

polo.csit (3/2/2015)

---

Hi All,

i am using the query

select id From Job where Title like '%java%'

it will take 10 sec time

after that i am using the Force Index Query Hints

like

select...

On the risk of sounding corny, welcome home Lynn!

😎

Cutting to the straight chase, cloud providers have no say about your M$ limitations or M$ contractual capacity, either you got this wrong or your question is wrong (maybe both?)

😎

Jeff Moden (3/1/2015)

---

Outstanding. Thank you VERY much for the time you've spent on this whether it may have been trivial or not, Eirikur. You obviously took some time...

Lynn Pettis (3/1/2015)

---

In Salt Lake City waiting for my last flight taking me home to Colorado Springs. I can't wait wait for this flight to already be in Colorado...

That would be the result set prior to the cross-tab or in other words, just remove the cross-tab case statements

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @table TABLE

(

...

evaduva (2/28/2015)

---

Hi,

Could someone please tell me what is the maximum size of a DB hosted on SQL 2012 cloud environment? I would appreciate if the answer came from a real...