Quick thoughts, don't use TEXT, use VARCHAR(MAX) or NVARCHAR(MAX) instead,

BOL: ntext , text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid...

Just chipping in a little bit, one of the bigger annoyances when importing data from Excel spreadsheets is the lack of metadata functions/view, think thousands of files with a time...

Great meeting you all, Ola, Erland, Itzik, Grant, Rodders, Gail, Dejan and and all the others, missed Steve although I did catch a glimpse captain America, looking forward to the...

Elementary my dear Dr. Watson Mr. Thomson

😎

krypto69 (3/6/2015)

---

Hi,

I have a statement that I'm having trouble converting:

select * from emails join InternalContacts On emails.EmailAddress = InternalContacts.EmailID

When I run this I get -

Conversion failed when converting the...

Has everyone picked the costume for tonight?

:smooooth:

Quick thought, the difference is mainly that the first code snip implies a group by which translates to a distinct aggregation of each set members by group, the over clause...

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

...