The books published by WROX have been a primary source for my education in asp.net, vb.net , SQL Server Programming and SQL Server Management.

Some time ago I took a class...

Thanks for your suggestion. I have submitted the article.

Maybe Steve will modify it for a question of the day.

Classes and books are great for learning the tools.

A project and a deadline will motivate one to find a use for the tools and dig deeper into resolving the issues...

I believe that a currency value should be stored as a 2 decimal value.

If you make a payment to someone, the payment is to 2 decimal places.

Your calculations can be...

Great article in today News Letter on Transaction Log.

http://www.sqlservercentral.com/articles/Design+and+Theory/63350/

Here are three different ways you may resolve your issue.

1) Try creating a view (query) that joins the three tables, like:

Select t1.column1,t1.column2,t1.column3,t2.column1,t2.column2,t2.column3,t3.column1,t3.column3, etc listing the columns you want to show

From...

Geez! Sounds like you are jumping into the fire head first!

I have been wearing many hats for the same company for over 20 years.

We started with an Alpha Micro...

Were you able to solve your problem?

I have a sample .MDB that I got online some time ago that shows how to concatenate rows of data.

If you want I can...

PuuuurFect:-P

Thanks for your timely response.

Marcus Farrugia (10/28/2009)

---

Hi Doug, don't really have a table structure, it would be from one column...

bitbucket-25253 (10/27/2009)

---

Frances L

You have posted your question to a site that assists users of SQL Server, with a question concerning how to perform a task in Microsoft's ACCESS.

You would be...

Marcus Farrugia (10/20/2009)

---

Hi, how would I write a query where I concatenate the data from each row into one string

ie,

col1

row1: 'a'

row2: 'b'

row3: 'c'

desired result: 'abc'

thank you...

How do you tell...

Frances L (10/22/2009)

---

I have those first name like below, I will like to extract middle initial

FIRSTNAME

[AARONb][/left] A

AARON ADAN

AARON BRIDGES

A DIX

A GERALD[/i]

A HUSSAM

A JAMES, III

A JEFFREY

I am trying to extract the...

Maybe the OP needs terminal services to connect and run the applications on the servers?