So you need to split the column by the '-'?

Here is a nice article by Divya Agrawal that may help you:

http://www.sqlservercentral.com/articles/XML/66932/

gbill (8/5/2013)

---

Thanks for answering my post.

I am not overly skilled in the SQL area, I am learning though. For example, once the SQL product is installed, are...

Again based on what you are look for this may or may not help you.

Use PowerShell to Quickly Find Installed Software

http://blogs.technet.com/b/heyscriptingguy/archive/2011/11/13/use-powershell-to-quickly-find-installed-software.aspx

It's a nice write up that shows you how to...

habitual

Soccer

vacation

Is the database to large to migrate them to Express Edition? Express has a database size limit of 10GB. Or is there an issue with using features in...

Best guess is that the account that you are using to run sql does not have access to the directory where the datebase files are located. ie c:\Program Files\Microsoft...

DataAnalyst011 (9/7/2012)

---

This is strange. One of my subscribed reports suddenly showed the wrong formatting (a decimal was supposed to be a percentage). So I checked the report in BIDS. When...

NIN

tyson.price (8/23/2012)

---

You didn't specify, other than by the eaxmple, but this will just eliminate leading...

Koen Verbeeck (8/24/2012)

---

ganeshkumar005 (8/24/2012)

---

for 'D1234', the first time it appears while reading from top, the value against it is 1001. I want this row in result. And skip the others...

ganeshkumar005 (8/24/2012)

---

I have a table:

D12341001

A11224001

D12342001

C13425001

B19646001

A11223001

you can see leftside values D1234 and A1122 are repeated. Now I want the result as very first numerical ID returned when I meet the alphanumeric...

I just wanted to post a followup on this.

We ran three test to the backup

1. Restored to a Physical Server

2. Restored to a another virtual server using nas instead of...

Thanks Steve. Just wanted to make sure we were spinning the cycles in the right location.