something like this?

DECLARE @tbl TABLE

(

col1 INT, Col2 CHAR(1)

)

INSERT INTO @tbl

SELECT 1 ,'A' UNION ALL

SELECT 2 ,'B' UNION ALL

SELECT 3 ,'C' UNION ALL

SELECT 4 ,'D' UNION ALL

SELECT...

LutzM (12/30/2010)

---

Nope, not in the version I checked (will be...

Did you try to setup a test scenario where the index would be used?

Edit: removed as announced. (due to inappropriate content.)

Pete23Mid (12/30/2010)

---

You can as well create databases / schemas for themselves and than change ownership to their logins. You can do it in any order you want, database first, or...

Congrats, Gus!! To climb the Olymp just before a new...

[SARCASM ON]

I don't think anyone involved in the NHibernate development should be allowed to write stuff like "I hate SSIS".

[SARCASM OFF]

Honestly, using...

Even if there is no "bottom of the column", you could either use WITH ROLLUP or you could calculate the values within your CrossTab. In order to control that total...

If you don't have a tally table already (which is very useful in several cases) you could take the "master..spt_values" apporach:

DECLARE @tbl TABLE

(

EntryID INT,

...

Brandie Tarvin (12/30/2010)

---

...

This isn't a POV issue, Lutz. It is, by every legal definition of the term, pure and simple copyright violation. It doesn't matter that he linked to...

I don't think you'll get the help you're looking for in a forum.

All we can do is point you in a direction or help you with a specific question.

But to...

danavni (12/30/2010)

---

Hi Lutz,

thanks for the message. these tables where built by me about 6-7 years ago when i didn't know too much SQL. when the tables where small and held...

If all this info is in the same table it's a lot more easier to create the query...

So i need to come up with a solution that do all this,...

rizkhan92 (12/30/2010)

---

Brother this procedure is not written by me it has written by someone else.

and i am a new internee over this organization..

thats y i ask you to solve this...

Regarding the table size itself:

I noticed you're using FLOAT quite often (e.g. for [X], [Y], and [Speed]). Float will use 8 byte.

You could change the Speed column to smallint (2...