Wallertown (4/11/2012)

---

Hi

I'm new to SQL and hope you can help.

I want the following:

I want a select query which selects the weight-field of a datatable.

But it shall only select the weight...

Ooo, ooo!! I've scanned it. Probably the only one though 😉

It's just a link to my linkedin profile, nothing special.

---

--edit--

SQLRNNR...

Jeff Moden (4/10/2012)

---

Cadavre (4/10/2012)

---

Matt Miller (#4) (4/10/2012)

---

Note: while cadavre's code will generate a sequence number within the query run, it's not a deterministic sequence number. As a result,...

Matt Miller (#4) (4/10/2012)

---

Note: while cadavre's code will generate a sequence number within the query run, it's not a deterministic sequence number. As a result, rows might get...

tonyarp05 61903 (4/10/2012)

---

Hi,

I have an table called type.

SeqAttributeTypeTypeid

15 10

21 ...

--edit--

Removed my post as it's less helpful to the OP than Gail's. My post was more of a spoon-feeding exercise.

You'd have to hope so, right? 🙂

Does anyone have a link or script to prove that using the physical table order to determine the order of your results is bad?

In reference to this thread.

This is your problem.

You're relying on the physical order of the table. This is not guaranteed by SQL Server so...

yingchai (4/10/2012)

---

Cadavre (4/10/2012)

---

Not really.

What I want to know is how can you tell which is inbound and which is outbound?

In your sample data, aaa and bbb are the FLAG1...

Not really.

What I want to know is how can you tell which is inbound and which is outbound?

In your sample data, aaa and bbb are the FLAG1 and FLAG2...

After 320 visits, you should know by now that you need to provide DDL, readily consumable sample data and expected results as per this article.[/url]

First, I've build some sample...

I know what you're thinking, it's far faster to not cast a datetime as a string so it follows that it'll be...

pixelwiz (4/4/2012)

---

Hi,

Let's say I have a table of locations (currently 3 but can grow), a table of customers, and a table of transactions.

I need to generate a report that shows...

On the same box, just tried a 1-11000 tally table and got the same results.

I guess it's a memory issue. When I've got more time I'll free...