Mile Higher Than Sea Level (12/3/2012)

---

Sorry about the cross up in terms. In Access code, we can Execute a query (of a SQL View).

I figured it out with some trial...

You should have somebody there read those...

Mile Higher Than Sea Level (12/3/2012)

---

In MS Access - a query can have a column defined as MyTimeStamp: NOW()

When the Query is run for a MakeTable or Select,...

Hi and welcome to SSC. I would love to help but there are not enough details in what you posted to be much help. Please take a look at the...

You're welcome. Glad that worked for you. 😀

bubby (12/3/2012)

---

I have to SQL Server and one has version,

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c)...

select tableA.Col, COUNT(Tableb.ID) as MyCount

from tableA a

join Tableb b on a.ID = b.ID

group by table.Col

Minnu (12/3/2012)

---

Hi Team,

BEGIN

SELECT RTRIM(

+ISNULL(Col_Name,'')+' : '

+ISNULL(+CAST(ColB AS VARCHAR(10))+' ','')

...

lex9120 (12/1/2012)

---

I'm not sure exactly what the result would look like because they're just asking it from me. However, I'd like to see what the guru's would write...

You're welcome. Glad that worked for you.

The last parameter is the criteria (it acts like a where...

sasansamani (11/30/2012)

---

I made myself confused and you. I need more coffee. I thought you were referrring to another field.

Right now my problem is how do I validate against another table?...

sasansamani (11/30/2012)

---

Actually my autonumber starts at 1000. You are right. How do I automatically assign random numbers for a 4 or 5 digit number? How do I determine if I...

Perry Whittle (11/30/2012)

---

This

selectobject_name(object_id) AS TableName

from sys.columns

where object_name(object_id) like '%table...

If you are using an autonumber you are going to have gaps. This is perfectly normal. Honestly, why does it matter if there are gaps?