installing sql server mobile in an hp ipaq rx1955

does anybody know how to install sql server mobile and the query analyzer in an hp ipaq rx1955? don't see the samsung processor in the processors list.

thanksWhat is the processor type?
ARMv4/ARMv4i/SH4/MIPS-II/MIPS-IV/MIPS-II FP/ MIPS-IV FP

What is the Windows CE/Mobile OS Version?
3.x, 4.x, 5.x ('About' button would tell you everything)

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||The iPAQ 1955 has the following processor: SC32442.

Which processor type should I use from the list?

Thanks|||This device runs Windows Mobile 5 and is ARM compatible.

The CABs you need are:

Location:
C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i

Files:
sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
sqlce30.ppc.wce5.armv4i.CAB

-Darren

Installing SQL server 2005 client tools.

I searched on internet

and documents, but could not find the steps to install only client

utilities for SQL Server 2005. I need something like Query Analyzer and

isql to connect to the database.
I selected client tools only after clicking setup.exe, but query analyzer and isql or Microsoft Server Management studio were not installed.
Any help will be useful.

Thanks

On teh Components to install dialog during the setup select the option : Workstation tools, Books Online and development tools and click on the Advanced tab at the bottom.

Under the Client Components node, select the client tools which you want to install and proceed further.

HTH,

Rajesh

|||what operating system are you using

Integers, Money values becoming zeros

Hi,

When I reset the SQL query in Database ->Show Sql Query, all integer and money type values are becoming zeros. When I execute the same query in the SQL Query Analyzer I am getting the values with same no. of records in the report. Can anybody suggest me the solution.

The only difference before resetting, the query doesn't have "WHERE" clause.

Thanks in advance.Post the query you used and the table structure

integer count

Im not at all familiar with sql programming text but i need to do something I cant find an example of. Im using the sql query inside of an access 2003 database. Basicall I have two tables. One that hold all the employees personal informaton AS WELL AS Total Days Worked AND TotalPoints.

A day worked is represented by a "w" form within my vb program.
I used to sql code:
SELECT COUNT(*) AS TotalDW
FROM TblEmpAttendance
WHERE Value="w" And TblEmployee.EmployeeID=TblEmpAttendance.EmployeeID ;

To get the "w" total or count in this case.

--This seems to work without a problem please let me know if you see a problem with it.

--Now on to my bigger problem.

The second table has 3 fields-- EmployeeID, Date,Value
The date comes from my vb program(a calendar with textfields to hold values)

However-- to limit the code I use in my vb program I wanted to take a point total for all points from the 2nd tbl

In vb I can use --IF Isnumeric --But I have no clue how to do it woth SQL code!!

A Point Value can only be 1 of 4 values(a 1,2,3 or a 7)

But how do I rewrite the below code(if below code is even close!) to count all of the numeric values for the field "Value" when not every entry for "Value is a numeric entry?

SELECT COUNT(*) AS TotalPoints
FROM TblEmpAttendance
WHERE Value= '1 or 2 or 3 or 7' And TblEmployee.EmployeeID=TblEmpAttendance.EmployeeID ;

Hopefully I explained sufficiently..Thanks In advance!Did you try:

SELECT COUNT(*) AS TotalPoints
FROM TblEmpAttendance
WHERE Value IN ('1', '2', '3', '7')
And TblEmployee.EmployeeID=TblEmpAttendance.EmployeeID ;
;)|||Nope but I will now..Thanks Much! it is highly appreciated..Just tried it...I only have 4 sample employees to check it with but it seems to work...
Many thanks!!!