Assuming your data in consistent (ROFL) you could do something like this.

declare @SomeValue varchar(20) = 'john fernandez'

select LEFT(@SomeValue, 1) + SUBSTRING(@SomeValue, charIndex(' ', @SomeValue) +1, len(@SomeValue))

This is why we store...

I still don't understand why you need the columns to be dynamic. The number of columns doesn't change. Code it once and be done with it. The dynamic solution saves...

Alan.B (7/2/2014)

---

Sean Lange (7/2/2014)

---

If you use the quirky update please make sure you read the article carefully. There are a number of extremely important requirements that must be met for...

If you use the quirky update please make sure you read the article carefully. There are a number of extremely important requirements that must be met for this to work....

sifar786 (7/2/2014)

---

I will surely look into crosstabs later.

Right now, can you help me with the sp and dynamic generation of columns as right now i am pulling my hair and...

You are quite welcome. The crosstab...

Read the articles I suggested. A cross tab is much easier to...

vecerda (7/2/2014)

---

OK< thanks, what I am trying to do is use pivot to create cross-tab between items and stores. Basically I need to figure out what each item costs in...

What you will need to do is create a new table with the structure you want. Then copy all the data from the current table into the new one. Drop...

vecerda (7/2/2014)

---

Hello there,

I am having trouble figuring out why the following code throws an error:

declare

@cols nvarchar(50),

@stmt nvarchar(max)

select @cols = ('[' +...

I wouldn't use PIVOT for this. I would use a...

Minnu (7/2/2014)

---

Hi Team,

I've a large table in my SQL database with more than 10 million records, i want to clean the table every week by

deleting the records older than...

I hope you have also made these guids a...

siri_rmsi (7/2/2014)

---

TITLE: Microsoft SQL Server Management Studio

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

Attach database failed for Server 'xyz'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2218.0+((SQL11_RTM_GDR).120612-1250+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

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

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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

Directory lookup for...

No problem. Glad that helped. 😀