Putting what everyone else has said aside, does this help....

If you are the type of person who learns...

shannonjk (4/7/2010)

---

Greetings all 😀

Recently my company migrated from a SQL 2005 server to a SQL 2008 server (both are up and running concurrently on different machines). Reporting services and its...

That depends on the "A"'s definition.

I'm a SQL Database ArchitecAdminAlyst 😀

I'm guessing that there is a puddle of pee under huslayer's desk right now... :hehe:

test for numeric:

ISNUMERIC(LEFT(yourFieldName,1)) = 1

😀

http://www.sqlservercentral.com/Forums/Forum392-1.aspx

Which version of SQL are you using? You've posted this in the wrong forum and may not get the proper advice.

If you're using 2005 or 2008 look at the PIVOT...

george.greiner (4/6/2010)

---

Does this also give me the ability to process a batch subscription. For instance if there are 10 finished files within the last 24 hours that need to...

This is a real shot in the dark since you seem to not have much say in the actual data collection process, but could you record the employee's "number" instead...

Can you post what you've tried?

This appears to be a homework or study question. And most of us here DONT have a problem helping, we generally don't want to do...

Yep, the batch continues on until it hits a 'GO' statement

Post your proc here. we can't debug what we can't see. 😀

AND

Read this ...

For better, quicker answers on T-SQL questions, click on the following...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Miles Neale (3/31/2010)

---

Hi Jason,

First of all what you have done is interesting and will work and very creative. Job well done.

There is however an alternative available that you might want...

Jeff Moden (3/30/2010)

---

I know, Dugi, and I appreciate your efforts. The problem is that not just the OP will read such a thing. Someone with similar but slightly...

SELECT ID FROM PART WHERE CHARINDEX('_',ID) > 0