frdrckmitchell7 (11/28/2011)

---

It's rather a simple question: I have a table with 25 rows being displayed vertically and I want to display it next to each other in rows of...

pushpi2000 (11/27/2011)

---

Hi,

I want to create views referring to invalid objects. The reason is that i don't have control on some, as of today, non-existing objects. How can i create such...

So use the example I posted above.

select a.col1, b.col2, c.col3, d.cold4, e.col5, 'x', 'y', null, null

from...

How often do I hear this but in reality it is not that the client requires the data to be stored...

On both copies of your question people are asking for clarification. Remember we can't see your screen and have no knowledge of your project. The details you provided are simply...

EdA ROC (11/22/2011)

---

Richard - Thanks!

What you know is correct.

And, I learned something else, because simply substituting for the column name didn't work. I also had to remove the ORD_MACH_OPS (table)...

From what you describe I don't think you need any kind of looping at all. You simply want to insert into a table some data when some conditions are met....

Or take a look at ssc stairway series on indexes. http://www.sqlservercentral.com/stairway/72399/%5B/url%5D

This is a super set of articles that takes from the basics to pretty in depth stuff. Make sure...

You know looping is absolutely horrible for performance (and you have nested loops which is even worse). SQL is designed to work set based and not row by row. Given...

Update MyTable

set MobileNum = '91' + MobileNum

where left(MobileNum, 2) <> '91'

Tom Brown (11/21/2011)

---

Sean Lange (11/21/2011)

---

Of course if you don't want to spend the money for pressurized cookware you can just add salt. Pressure and salinity will increase the boiling...

Of course if you don't want to spend the money for pressurized cookware you can just add salt. Pressure and salinity will increase the boiling temperature.

Actually there was a method presented that will work most...

psjrw (11/19/2011)

---

Hi, and thanks for your idea about encrypting the Global.asa file. We think alike. Currently I left the global.asa the way it is as a decoy. But...

Here is an example query that will work and do what you are trying to do.

;with ReturnList (SomeValue)

as (

select 'rdwqyx41pe' union all

select 'reyewmf0wv' union all

select 'rjm6d08pmt' union all

select 'rlgv05xc40' union...