roryp 96873 (5/5/2016)

---

Ray K (5/5/2016)

---

I can well imagine!

Just heed the warning of history! It's only May. Bigger collapses have happened in only a short period of time! ...

This feels good for a change...

Something like this perhaps (I'm just guessing on the rank)...

-- Sample data

DECLARE @table TABLE ([Year] int, Region varchar(20));

INSERT @table VALUES (2013, 'South'), (2014, 'North'), (2015, 'South'), (2015, 'North');

--Review:

--SELECT * FROM...

There are two ways to look at that question and, since I was not there I can't say for sure what they were asking.

If they wanted to know how...

I think you can (go to msdn.com to find out for sure.

SQL 2005 has been retired fyi.

A couple things here.

First, the message is pretty clear. The SSIS package is failing because the login for SA, inside at least one of your SSIS connection managers is...

drew.allen (5/4/2016)

---

I would phrase that differently. They all take ties into consideration: RANK and DENSE_RANK treat ties...

Another way. And this will work for multiple trailing numbers or when there aren't any.

DECLARE @strings TABLE (LoginID VARCHAR(100))

INSERT INTO @strings

VALUES ('adventure-works\peter0'), ('Northwind\mary009'), ('Test\mark');

SELECT SUBSTRING(p, 1, ISNULL(NULLIF(PATINDEX('%[0-9]%',p),0),8000)-1)

FROM

(

...

ROW_NUMBER does not take ties into consideration, RANK and DENSE_RANK...

Note that, unless you ABSOLUTELY need it for some reason, you should get rid of that final ORDER BY statement. It will only slow down your query and does not...

Me too.

Yusuf Bhiwandiwala (9/18/2009)

---

tmacs33,

The question is : How do we grey out a report parameter (date type or not)?

If greying out can be achieved, the SSRS world would be a happier...

Eirikur Eiriksson (5/3/2016)

---

Alan.B (5/3/2016)

---

Eirikur Eiriksson (5/3/2016)

---

Alan.B (5/3/2016)

---

I think this is a common problem in the data world for sure.

It all comes down to self-awareness and communication. Knowing your strengths,...

Eirikur Eiriksson (5/3/2016)

---

Alan.B (5/3/2016)

---

I think this is a common problem in the data world for sure.

It all comes down to self-awareness and communication. Knowing your strengths, weaknesses and limitations,...

You'll find some scripts that you can alter as needed here as well.