Geoff A (5/20/2014)

---

i came up with a solution. not pretty but it will work for now...

declare @bo-2 table ([ID] int, Col1 varchar(50), Col2 varchar(50), col3 varchar(50))

insert into @bo-2...

aberndt (5/20/2014)

---

As I explained earlier, I do not have any experience creating tables. I appreciate your patience. I found enough information to successfully create the temp table. ...

Cool glad that works for you.

aberndt (5/20/2014)

---

Here you go.

CREATE TABLE #mytable

(

ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

...

Since I can't see you screen it would be very...

Or maybe the actual order doesn't really matter and you can just do this?

select Col1,

Case LEN(Col1) when 2 then Col2 else '' end as Col2,

Case LEN(Col1) when 2 then ''...

aberndt (5/20/2014)

---

I am attempting to follow the instructions for trying to compile some test data and I keep getting the error message 'Invalid Column Name'. I am obviously missing...

Wowie Zowie!!! This is a lengthy procedure. There are so many things that need to be dealt with here it would be far easier to just start from scratch.

Cursor...

There is no way to do that with the sample data you provided. There is nothing to indicate an order and without a column to use as a sort there...

aberndt (5/19/2014)

---

Hi - I'd like to create a view where I can select one value from the previous row in the table. Can a query be written that does...

vasuarjula (5/19/2014)

---

Hi,

I am having a hard time in making case expression work in T-SQL. Please see below script. I have created a sample script and testing it, but it is...

A better approach here would be to...

Yes you can replace multiple spaces with a single space much easier than this.

http://www.sqlservercentral.com/articles/T-SQL/68378/%5B/url%5D

It looks like you have a mountain of nested replaces in here for a number of other...

tshad (5/19/2014)

---

I was a little confused.

I know you can only use whatever values are actually passed back (defined) from the CTE, I didn't know that the value remembers which row...

Glad you found a solution. I would still suggest that you should fix the web app to handle user data, not modify user data so that the website code can...