You know what would really help, show us what you are trying to accomplish with sample data. Right now we are all just guessing at what you are trying...

I'll forward this Thread to our PeopleSoft Admin. All I do is restore the production databases, she takes care of evrything else.

GSquared (3/9/2009)

---

So, if one of the results is 123 and the other is 456, you want to end up with the number 123456?

Can you multiply the first one by the...

A Little Help Please (3/9/2009)

---

Somthing strange is happening?!

I have restored a SQL 2000 DB on to a new SQL 2005 DB.

When I run:

select top 100 * from tbldeals

order by trade_date...

You have to wonder what people are being taught when you see code like this:

ALTER TRIGGER [dbo].[tr_insert]

ON [dbo].[table1]

AFTER INSERT

AS

BEGIN

...

GilaMonster (3/8/2009)

---

I've seen it, long, long ago. Can't...

Noooo, please don't say it!

I would not call it competition, I'd call it having a partner. Who says there can be only one Saint in the forum?

CTE (3/7/2009)

---

will you stop being so stupid?

When the hell I said My query is BEST? stop imagining. Get life.

Now I'll talk in the language you will understand.

Enough of...

He may have agreed that Bob's solution was better, but he also kept trying to defend his solution as it was something he came up with. A lot of...

Great, you like CTE's. Guess what, Bob's solution is also a CTE. What we are trying to get you to understand is that just because your solution works,...

t.walker (3/6/2009)

---

I really support that idea. I think a more private invited members forum would enable me to speak more freely/

Although I am a rookie here, I am also a...

I can't see an exclusive thread or forum really working here. If that's what it would take for someone to feel comfortable here at SSC, maybe this isn't the...

Jeff Moden (3/6/2009)

---

Lynn Pettis (3/6/2009)

---

Not the request I made. I know which I'd use. I want Mangal to justify to me why I should use his solution even...

CTE (3/6/2009)

---

You should use Bob's solution, best way create Time dimension and use it.

One question came, I given 1 solution, which is not that bad, another person gives another solution,...