Your pick:

DECLARE @TestStr VARCHAR(20) = ' Q2ERY56,920 TYEU';

SELECT @TestStr;

WITH eTally(n) AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) FROM sys.all_columns a CROSS JOIN sys.all_columns b)

SELECT

NewString =...

Depends on the OPs actually requirements.

You mean something like this?

DECLARE @TestStr VARCHAR(20) = 'Q2ERY56920TYEU';

SELECT @TestStr;

WITH eTally(n) AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) FROM sys.all_columns a CROSS JOIN sys.all_columns b)

SELECT

NewString...

Regarding IsNumeric, you may want to ready this: http://www.sqlservercentral.com/articles/IsNumeric/71512/.

I purchased the SQL Server 2012 Developer Edition on Amazon.com for $43.00. Not that much of an outlay to get a full blown version of SQL Server 2012 for...

yogi123 (1/2/2013)

---

Thanks for your help

can you please solve another way, so i can implement that in my real logic.

Thanks For Your...

Thank you Steve for the prize. I will be back next season for sure, have to see if I can threepeat the championship!

dwain.c (1/2/2013)

---

Lynn Pettis (1/2/2013)

---

dwain.c (1/2/2013)

---

Tava (1/2/2013)

---

To answer the question about why is DateID int and not datetime its an old table and data already in there. I assume its for...

dwain.c (1/2/2013)

---

Tava (1/2/2013)

---

To answer the question about why is DateID int and not datetime its an old table and data already in there. I assume its for an indexing/performance benefit...

From http://msdn.microsoft.com/en-us/library/ms179344(v=sql.105).aspx

High-Safety Mode Without Automatic Failover <--- Your configuration

--------------------------------------------------------------------------------

When the partners are connected and the database is already synchronized, manual failover is supported. If the mirror server instance goes down,...

dwain.c (1/1/2013)

---

You might try this:

SELECT CompanyName, Type

,Sunday=MAX(CASE WHEN weekday = 1 THEN Val END)

,Monday=MAX(CASE WHEN weekday = 2 THEN Val END)

...

Disclaimer: I am not a legal authority and the following is only my opinion based on my understanding of the developer license.

Each developer will need a licensed copy of...

It is in your...

Check the code used in the job step. Not enough info to really say much more.

Jeff Moden (1/2/2013)

---

Lynn Pettis (12/31/2012)

---

Another reason for the table aliases and 2-part naming convention is the Microsoft has deprecated the use of 3- and 4-part naming conventions in SQL Server....