hi,
I have a table which is a Master to other 12 tables and it is Child for
other 2 tables.
Therefore, It has 14 relationships with other tables. The size of table is
very small. (approx 30-40 rows). It also has a clustered index in its primary
key.
The problem I am facing here is that wh...
more >>
How can I retrive data from a table in MS Access database within a
specified range of date?
...
more >>
I am a bit of a newbie to SQL Queries and need some help with the following
query.
I have two tables in SQL 2000 which hold info about user and roles.
In the first table I have a set of user info containing the user name and
its email address. the user name is the primary key in this table...
more >>
Is there an easy way to set a default value for values in unmatched rows
that return null
I wouldlike to return 0 for fields that return null in a left join ...
more >>
Is it possible to create a query that returns a count of each
application_request_detail_status_type_id as columns?
Any help on this would be greatly appreciated, thanks :)
...
more >>