Hi Antares686,

quote:

---

always work exactly rigth) unless you are able to set your email app to "Open In a New Window".

---

Oops,

I hit ENTER too early.

Maybe something like this will work

SELECT a.transaction_date, a.ending_balance, b.beginning_balance FROM table a INNER JOIN table b ON a.transaction_date = b.transaction_date.

Haven't verified this!

Cheers,

Frank

Hi Anbu,

sorry for being late.

If you need a quick working solution, create a temp table and push everything you need into that table instead of wasting time figuring more or...

Hi Anbu,

do you want this for reporting purposes, or do you want to add a new row?

Cheers,

Frank

Hi BillyWilly,

quote:

---

Is there a happy medium or "standard" when creating decimal types???

---

in most cases there...

Hi Shawn,

quote:

---

Is there a way to categorize Local Packages and Jobs so they can be viewed in an explorer like view. When...

Nun ja,

vielleicht liegt es ja an der englischen Sprache. Ich kann das wirklich nicht glauben. Heisst dass, dass Bedarf an einem deutschsprachigen Äquivalent besteht?

Cheers,

Frank

Hi all,

quote:

---

Just my opinion but I think that the lack of experienced SQL Server DBA's is going to be the hardest thing...

Hi hawg,

subscribing to MS security alerts is a starting point I also use. Further I keep my eyes open while joining forums like this one. There are also mailinglist from...

Hi dambalaji,

not exactly what you were asking for, but...

I've posted this some days ago, it's a script I found on the homepage of a SQL Server MVP.

CREATE PROCEDURE sp_rpttblspc (@dbname...

Hi gmg,

no, normally timestamp should be automatically added when a new row is inserted.

Have you check through QA?

Cheers,

Frank

Well, he is honest

quote:

---

What a professional advertisement and first impression of your "company."

---