In VB I can use debug.print cstr(round(3.14159,1)) and I am getting "3.1"
What is a good practice of rounding fractures to a given precision:
select 'high threshold ' + cstr(round(PI_LIKE_D...
This query works fine
"SELECT * FROM CA_Class_Attend_Detail "
BUT I need to pull just the current dates attendance so would like to try something like this
"SELECT * FROM CA_Class_At...
I have this sql statement that works, however I only need the most current date record. the date field is: LDATET
I assume I need the max(LDATET) but dont know how to work that into my sql...
I have a temp table:
create table #TempMappingItems (c1 int)
I need a condition to determine whether this table exists. If so, I want to delete it:
if #TempMappingItems exists
then drop ...
I read in WikiPedia about this query, which really works. But I need an explanation of what it's actualy doing.
SELECT MyToy.dbo.employee.LastName, MyToy.dbo.employee.DepartmentID,
(SEL...
Hi there,
Am at the moment doing some analysis for a project where we have some data on a sybase database which needs to be replicated (in the most general sense of the word) to a sql server ...
Hi
I would like to pass a where clause as a parameter (e.g.: FirstName Like '%Jo%')
When I run this stored procedure in query analyzer I get:
Incorrect syntax near ')'.
Invalid object...
I have a table like:
Time Point Distance
10:00 A 0
10:10 B 17
10:20 C 3
10:30 D 12
10:30 E 5
10:30 F 2
....
Distance column represents distance between the last point and the ...
I have data that looks like this:
TaskID Name OutlineLevel Outline Number
-------- -------- -------------- ------------------
1 ...
Using "Apply to Selection" need to pick up and use a variable.
The line to replace is:
APPLY TO SELECTION([dummy];[dummy]arr1:=999)
Using the variable:
$var:=1
And somehow substitut...
Let's say I have two tables.
One is a table of images that has the columns PicID and PicPath, the other keeps track of categories for the pictures, and has two columns: PicID and CatID.
One...
These queries worked:
/* left */
SELECT *
FROM employee LEFT OUTER JOIN department
ON employee.DepartmentID = department.DepartmentID
/* right */
SELECT *
FROM e...
Hi,
I am trying to update an Item description on my Item table from the results in an SQL statement from another Database. The items have the same Item lookup Code, but the descriptions nee...
I have a very large data set each query can cost me two hours. I run one query in one Query Pan my trans table has 1000m records and I want to run update on my trans table at deferent pan for ...
I have written a program that writes data to text files. For one of the textfiles I need to check the date 30 days in the past and write the data results from that date forward. The code I'm...
Does anyone know what type of database MedWare by Sage uses?
Hi
I have a desktop application with an embedded database [SQLite]. I also have a website with MySQL database on it. I want to update the embedded database on the local machine with the cha...
I have a vb module that exports multiple queries to a formatted excel workbook. on one column i would like to convert the minutes in those cells to hh:mm. The number of rows/cells will always ...
I have a baseball team and a table that I want to get the rank using only a sql statement. Is it possible with the table below ?
Table-------------
Gamedate Hometeam points...
I need to design a database schema for an angling clubs that lists the history of the club.
I need to store details of
anglers (personal details, address etc)
who belong to a
clu...
Hi,
Is there a way to select from a filtered (while selecting) field at the same time? E.g. I have a table named "info" like following. I need to remove all "-X" and left with only the nume...
Hiya,
I'm not sure if this is a question with a straight forward answer or not really..
I have a table "Towns": Town_Id Name
and a table "Areas": Area_Id ...
I was asked this on an interview, and did not get the job. What would you answer?
Thanks,
newbieweb
I know, probably really dumb question, but I've never used sqlite and I don't even know how to start it. If there's a sqlite db named sample.db how do I fire it up and view the contents?
Hi All,
I am very new to SQL I am trying create a table and insert this data using teh following query but it gives me warning message
Warning: Null value is eliminated by an aggregate or ...
