Recent content by shuklix

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