I don't know of a way to bypass the design of the table without modifying the design.

The real question is why you'd want to bypass the structure of the table....

Perspiration

Lowell (3/24/2016)

---

there's at least two other longer than normal hyphens that has a different ascii code than the "normal hyphen ASCII('-')=45,without even going into nvarchar data sets.

i'm betting it's one...

ChrisM@Work (3/24/2016)

---

Alan.B (3/24/2016)

---

I was curious and looked at the thread.

ChrisM@home (10/22/2012)

---

yuvipoy (10/22/2012)

---

Ok, thanks. Can you give an example of how the data from this output table would be used...

One sure-fire way to shrink tempdb back to it's original size is to bounce the SQL Server service. Tempdb will be rebuild with it's original size.

However, what Grant said...

I like Alan's solution, but I'd never want to move my monitors; I'd move the windows instead. 😛

Seriously, why the restriction on temp tables?

kaplan71 (3/24/2016)

---

Hello --

Thank-you for your reply. At the risk of looking like an idiot, the syntax that I used was the following:

The output...

I have to agree with J Livingston - the logic doesn't match with the description of the goal.

To get you started, you said that you want to select the earliest...

GilaMonster (3/24/2016)

---

ChrisM@Work (3/24/2016)

---

Grant Fritchey (3/24/2016)

---

Steve Jones - SSC Editor (3/24/2016)

---

WayneS (3/24/2016)

---

Yes it does... even those that speak frequently. I know of a...

Breathe

Brandie Tarvin (3/24/2016)

---

Curious about other people's morning (first few minutes / first hour at work) routines. What is yours?

Mine is: Open email, two copies of SSMS (one non-prod, one prod...

ChrisM@Work (3/24/2016)

---

Ed Wagner (3/23/2016)

---

ChrisM@Work (3/23/2016)

---

Eirikur Eiriksson (3/23/2016)

---

ChrisM@Work (3/23/2016)

---

How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I...

ThomasRushton (3/24/2016)

---

Property

This is something I've done (not on 2014 yet) but never feel like I have down to a science. Maybe because I do it so infrequently that I don't...

Nice...