GilaMonster (2/5/2014)

---

MinhTuCSharper (2/5/2014)

---

So beside .NET and SQL Server, what is the hot MS technical field out there that on high demand, I'm willing to learn whatever MS Technology to get...

Koen Verbeeck (2/5/2014)

---

Switching careers just for the money is usually not a good idea. You have to make sure you will actually like what you are going to do.

Being a...

hemp

There are plenty of top notch people that have specialized in various things with SQL server. Even with that, there is a lot to learn and plenty of effort...

EXCELLENT cartoon.

Love that cartoons are coming back to SSC.

Gary Varga (2/5/2014)

---

I like a good laugh and did enjoy this but mainly I am here for SQL Server knowledge and experience (both receiving and imparting).

I hope that is not...

That would mean that you have other urls that do not fit the patterns you have provided. I couldn't tell you what is different not having much of a...

Not sure I fully understand your question.

But if you mean replace everything after the ? with an empty string, then it wouldn't be very useful or efficient. You typically...

Of that small sample set, the following is throwing a curveball

/trwmjh.asp?Info=m/Txnxt1AKNvdWkS

The issue is the / that comes after the ?. Is this a valid url?

In any case, this should...

Are you able to handle those NULL values in the query for the datasource for this report? Changing that NULL to a different value such as 0 is a...

You probably have some null values in the table. Or you have some urls that do not fit that pattern.

Having a sample set of data would have helped to...

Well this should work for you

DECLARE @blah TABLE (someblah VARCHAR(256))

INSERT INTO @blah

VALUES ('http://www.xyz.com/region/department.asp?FID=8907')

SELECT REVERSE(SUBSTRING(REVERSE(someblah),CHARINDEX('?',REVERSE(someblah),1)+1

,CHARINDEX('/',REVERSE(someblah))-CHARINDEX('?',REVERSE(someblah),1)-1))

FROM @blah

Can you provide a little more information such as the table structure and 20 or so sample records for this table?

Having this kind of information is extremely helpful in being...

Do all of these URLs have the ? following the asp? Or do you have different page extensions too such as htm html asp etc?

That information will play into...

That would pretty much be it. That is a fairly basic overview of it - but I think you are getting the gist.