Search results for query: *

It's an teaching organisation with lots of pdf, video's. ;) Saurabh

m6.net has good hosting package, anyone has any comments on them ? http://www.m6.net/web-hosting-prices.asp Saurabh

I am happy to pay around 40 USD/month. webhost4life did not turn out good for me. Their sales rep told me for 2 Gig disk space I need to pay 24.95/month but after I signed up they raised it to $49.95 :( Saurabh

Dear D'Arcy, I like it. They have a referer code which I am happy to enter for you while signing up. If you have a referrer code, please give me to soon. I will sign up as soon as I get it from you. thanks again, Saurabh

they do not change for bandwidth!! it's too good to be true. thank you! Saurabh

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)...

Thanks Tony, the orderDate is not indexed. I changed the where clause but it did not help. My guess is that there is some problem with the LEFT JOIN. The same query (mentioned below) without the LEFT JOIN, runs with in 25 seconds. SELECT COUNT(distinct m1.ordID) as count from ORDER as m1 ...

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

Found the solution. I should have used '%sa%' instead of '*sa*' Thanks, 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 =...

I read the 2 links. Still can not see, where I am going wrong ??? Saurabh

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 =...

I am using a SP. select top 5 id,name, email from Client works. but select top @offset id, name, email from Client does not compile. any thoughts ?

I just happened to read this post. http://www.sqlmag.com/forums/messageview.cfm?catid=5&threadid=8785 It says Top takes a lot of time. MY Table has huge number of records. Thanks a lot for your suggestion James. Saurabh

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...

I can not have Sql Server 2000, I have to use sql server 7. I would not like to drop the constraints. I can always handle it when I am writing my SP's. I just thought there may be an elegant and better way of doing it. Saurabh

Thanks James!! I am using MS Sql Server 7. Now the question is, how do I go about implementing it in Sql Server 7, should I create triggers ? thanks, Saurabh