barryocteau (6/1/2012)

---

Want to perform a simple SELECT * query and ORDER BY [ColumnX] ASC.

A simple single column query of, say, names.

Would like to organize the data returned as such:

A

Apples

Appricots

B

Banana

Blue Berries

C

Clementime

....

.....

Not...

There's way too much there for me to type it all out, so I'll give you the general idea and you can take it from there.

First, let's put your XML...

farooq.hbs (6/1/2012)

---

Hi

I have Values Like this

Project Name ...

Because it makes me a better developer.

I've been working with SQL Server for 3 years (nearly), and have been on this site for the last 2 years. I'm a junior...

I think Itzik Ben-Gan explores what you're asking about here

SQLKnowItAll (5/29/2012)

---

No reason to use Jeff's splitter if the data format is constant:

use tempdb

go

declare @test-2 varchar(125)

SET @test-2 = 'barrington, il 60010-4020'

SELECT RIGHT(@test, 10) AS zip, SUBSTRING(@test, CHARINDEX(',',@test)+2, 2) AS state,...

AndrewSQLDBA (5/29/2012)

---

I think what is really making this more difficult for me is that the second delimiter is a blank space. I am not wrapping my head around that easily....

As of the last time...

Do you want simple or fast? 😉

Technically, if you can use CLR...

USE

Did you try searching first?

This: -

EXEC sp_rename N'[srvrpf].[<Name of Missing Index, sysname,>]', N'WHATEVER_NAME_YOUR_WANT_HERE', N'INDEX';

Or...

CELKO (5/28/2012)

---

>> I have two tables Users and Alpha, where I loop through table Alpha and update table Users. <<

NO. SQL is a set-oriented declarative language. We do not loop...

First, this is how you should post your sample data: -

SELECT WorkId, WorkName, CurrentStatus,

ActualStartDAte, ActualEndDate, ParentWorkId

INTO #yourTable

FROM (VALUES(100,'Define','Proposed','25-05-2007','26-06-2008',100),

...

If I was asked this in an interview,...

Fizzbuzz is your evil interview? Really? It's as old as dirt (as are the solutions) 😛

WITH t1 AS (SELECT 1 N UNION ALL SELECT 1 N),

t2 AS (SELECT 1...