I think Luis' solution is the way to go. To answer your question about the trailing hyphen - you could go with:

AND QuestionableColumn NOT LIKE '%-'

As Drew mentioned, this will...

2016: The Movie (Trailer)

Sean Lange (1/3/2017)

---

The real downside is that overall it really seems like the number of questions has significantly decreased over the last 6-12 months. Hopefully this is just a trend...

Switching gears a little... If your statement is in response...

drew.allen (1/3/2017)

---

Alan.B (1/3/2017)

---

This wont work because you can't nest aggregates like this so we'll have to break out the RANK Window Function like so (including sample data so you can...

I'm no expert at either but have worked with both. I'm going to assume that by, "Postgres on AWS" you are talking about Redshift.

My experience has been that a beefy...

So what you want is the MAX(COUNT) of sales for each (e.g. "GROUP BY") EmployeeID by Month and Year. Let's start with some sample data; since you did not provide...

Great post Steve, 5 stars.

I found out a few weeks back that my department is moving to Phoenix AZ. I did not chose to transfer so I'll be back...

sgmunson (1/2/2017)

---

Jeff Moden (12/28/2016)

---

IIRC, PARSENAME has an element length of NCHAR(128) as a limit on each part it returns and is heavily dependent on the consistent position of items but...

Zososql (12/31/2016)

---

I have created a series of reports via vs2010shell - SSDT - sql2012, wondering whats the best way to publish these on an intranet where other workers can access...

😛

I did make the assumption that there...

mcfarlandparkway (12/27/2016)

---

Set based approach? How to do this?

How to parse(split) this 9000430944:7|Information

-> 9000430944 - emp number

-- 7 - stud number

--Information - Description

How to split on pipe? and How to...

comic_rage (12/27/2016)

---

Hi,

Thanks for the input, is this correct approach,

In my VIEW, vMyTable

select col1,

isnull(column50,1) as column50,

column51

from dbo.MyTable

where Column50 = 1

In the MyTable indexes, I added the following script

create nonclustered index ixIndex_Column50...

I'm with Jeff, there is no substitute for T-SQL expertise and database design. SQL Server Developer edition (2014 and 2016) is identical to SQL Server Enterprise except that you can't...

I don't see any problem with using a leading bit column for an index. I can think of many more examples where it would be appropriate as part of a...