Grouping records from 2 (or more) different tables
Fri, 7 Dec 2007 05:07:01 -0800
Hello,
I log all actions of the users in a table. Each day, I create this 'logtable'.
It looks something like this:
Tablename: 20071207 (for logs of dec 07, 2007)
Recnr
Userid
ActionID
Now, i want to create statistics on the actions that users perform.
If I only use 1 table, there is no problem ...
|
How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation?
Wed, 21 Nov 2007 13:42:07 -0800
How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?
...
|
Cross tab based on DateDIFF
Thu, 15 Nov 2007 10:44:02 -0800
I'm trying trying to build a crosstab query using a Case statement to count
the number of records in one column with the DateDiff >=0 and the other
column to be a count of the Records with the DateDiff <0. I can do this
easlily in MS Access with the IIF Function in a crosstab query but I can't
get the Sql St ...
|
Query syntax help
Thu, 15 Nov 2007 16:11:44 -0000
I am trying to write a query that returns all suppliers within a given range
that either do not have any insurance (appear only in Suppliers table) or
Suppliers where the insurance has expired from a given date
Eg 4 Suppliers
Supplier1 - no insurance
Supplier2 - insurance expired
Supplier3 - insurance curr ...
|
Counting in SQL Queries
Wed, 14 Nov 2007 10:17:03 -0800
I am working on creating a Report using SRS but first have to get the correct
information out of my database with a query.
What I am attempting to do is create Honor Roll for one of my schools, and
the requirements for the Honor Roll is a gpa >3.0 and less than 3.99, and
they are only allowed to have one C o ...
|
adding a query as parameter using 'contains' logic
Tue, 13 Nov 2007 12:53:02 -0800
Hello,
Setting parameter ranges for a query is very useful.
How can I specify : begins with ...... and make that a parameter (in this
case first 5 digits of a project name)?
Liek '%[parameter3]%' does not work.
What should it be?
Help much appreciated,
An 'over-his-head' Texas Tonie ...
|
SOFTWARE for SALE!!!???????????????????????????????????????????????????????????????? 92602
Saturday, 10 Nov 2007 19:38:53 -0600
Software for sale. Huge Selection. 10 Euros/CD. Worldwide shipping.
Windows, Mac, and Linux. The very latest software, stock video/photo, games, etc.
Contact David for details:
david007@worldnewstonight.net
...
|
|
|
Use distinct on one column but want 2 columns of data returned
Thu, 1 Nov 2007 14:36:02 -0700
Thank you in advance for any and all assistance. I am trying to do a
comparison of 2 tables and I am expecting the result to be what ever is not
in one of the tables. The table I need the result from has 2 columns of data
that I want returned based on col1 being distinct because I know it has
duplicates in ...
|
Table Query
Mon, 29 Oct 2007 19:06:01 -0700
I have a table that has the following three fields and values that I am
trying to build a query on;
Column name-FEDERAL, FICA1, FICA2
Values- 1 , 100 , 200
2 , 300 , 400
How can I get a query to look like this?;
Column- TaxCode, Value
Values- ...
|
Select Formatted Text From Table
Wed, 24 Oct 2007 08:59:01 -0700
Hi,
I have a text column in a table and data stored in it contains formatted
text (with carriage returns, tabs, and spaces). When I perform a select on
that column, data returned is non formatted. How do get the formatted data? ...
|
