kirkm 55368 (4/29/2012)

---

Hi,

I want to build a query on Multiple Tables... there's 3 tables in total. If they all had a 'Field1'

how could I output all fields (in all 3...

I haven't tried to understand your SELECT query and, as you did not expand on what you meant by "not working", I had to guess that there was a syntax...

Mikalina (4/29/2012)

---

Hello,

this is rather urgent..

I have a population of people who got less than 3 coupons, and i need to insert one specific coupon to that population (the one that...

Bill Nicolich (4/27/2012)

---

Before I go and build the schema, I'd like to compare notes with whomever has either seen this done before or has done this before.

I'm looking to create...

Thank you very much John. One coffee later and I was just about to post back that I had worked it out along the same lines.

I think that this is what the OP is after - not some complex forensic solution. Time will tell.

Why are you doing this?

deebabat (4/25/2012)

---

when i ran the select count (*) statement of the where clause, i got this error message: Msg 8114, Level 16, State 5, Line 1

Error converting data type varchar...

Any reason why you wouldn't shrink it? There might be a...

david.alcock (4/25/2012)

---

Just wanted to ask, if a log file has got too big and then subsequently a log backup has been taken, the recovery mode switched to simple but the...

You need to remember that SQL Server is a server tool and MS Access primarily a client tool.

It sounds like you will be able to get a long way towards...

Seriously? How about adding "rows > 1000" (assuming you...

kiran 4243 (4/24/2012)

---

Hi,

Can you please explain how i can create a lookup in sql server like the one in ms access. Is it possible in sql server ?

Please help with...

Helpful as always...

If you check out the OP's other posts (try this link), you'll rapidly come to the conclusion that the answer is 'no'.