Search results for query: *

Hi All, Due to a regulatory requirement we have to move our webserver from Australia to US. Can any one please recommend a good Asp.net webhosting company based in US . We would be needing: 1) Asp.net 2) around 35 GB traffic (outgoing), 1 Gig incoming. 3) Jmail (asp email component) 4)...

Hi All, I have 2 tables Order and OrderDetail(see below). Order has basic order information and orderDetail has more information on the order. One entry in order can have zero or more entries in OrderDetail. I am preparing a report where I have to find. Orders that have no entry in...

Hi Is there an equivalent to sequence(in oracle) in Sql Server ? I need to have a auto incrementing sequence of numbers which would be used as a primary key for the table. Saurabh

Hi All, I am trying to use a like clause to search for records from Access Db. How the query does not return any rows. When I run the same exact query directly in access it works perfectly. Dim selectSQL getConnection() ' gets the connection Set recordSet =...

HI All, I am trying to fetech 2 int, 1 decimal and one resultset from a Stored Proc. here is my codlet ======================================================== set Command2 = Server.CreateObject("ADODB.Command") Command2.ActiveConnection = ACBD Command2.CommandText =...

Hi Every one, I have a Table which has. Id , Name, Email I have to fetch 10 records every time, and have links to previous/next on all the page, and the sorting is done not on Id but on Name/Email field. I get my 1st 10 records by sorting on Name, How do I get the next 10 records. I can...

Hi All, I have a query of the type select expr1 + expr2 from T either of expr1 or expr2 may be null. I get a NULL when one of them is NULL, is there a way to change it to 0 ? TIA, Saurabh

My query is select CAST( visits as Float)/Cast(impresions AS Float) from Table T. visits -- Integer impressions -- Integer and visits is always less than impressions, so visits/impressions < 1. The value which I get is 4.8000000000000001E-2, is there a way to see the decimal value for this...

It seems like I am having a bad day! can any please please point at the mistake in the following peice of code. CREATE TABLE Sale ( saleid integer NOT NULL, clientid integer NOT NULL, productid integer NOT NULL, saledate datetime NOT NULL, CONSTRAINT pk_sale_id primary key...