Search results for query: *

Here is my requirement: 1. I have a text box (lets say txtStore), which accepts some integer values. This is a mandatory field. User can just enter an number and if he/she hits enter we need to retrieve some values and display it. 2. Screen also has some other fields, which are mandatory when...

DELETE TAB1 FROM TAB1 T1 INNER JOIN TAB2 T2 ON T1.Value = T2.Value Thanks, Pankaj

As far as my knowledge goes it all depends on the setting of ANSI NULL. using IS NULL for null values will always work but = NULL will work only based on the ANSI NULL settings. Correct me if I am wrong. Thanks, Pankaj

I tried running the Query plan for both the queries and they are exactly the same. Not sure, which way to go from here. Anyway thanks a lot for the help. Pankaj

Will there be any difference if there is no index on the column used in the Datediff.

Can some one advise which of the below queries should be prefered over the other and why? Select ItemCode from dbo.ItemStoreAd Where DATEDIFF (D,getdate(),AdEffectiveDate) = 0 Select ItemCode from dbo.ItemStoreAd Where AdEffectiveDate between '2003-07-15' and '2003-07-15 23:59:00'

I am not sure what you mean by "If your table is on a remote server". I am trying to build an HTML page having a Table which is bound to a datasrc(xml string fetched from database). After the binding is done and the table is generated, I want to move the rows using moveRow() method. I...

I have a table, which is build using the databinding. We need to move a row from a particular position to the new position. To acheive this I am using moveRow() method, but it doesn't seem to be working. Wheras if I use this method for a normal table(not build using databinding), things work...

I got what you are saying. Thanks for all the help. Pankaj

No. I am not trying to do this. Let me explain this a bit more. Let's say have 3 folders, Main, ASPs and Reports. Main folder contains ASPs and Reports folder and is made as a virual directory let say "TSP". Now if the user wants to access any ASP page he/she has to type in the URL...

Could you please tell me how to give an alias. An example would of great help. Thanks, Pankaj

I have also tried this function, but it is of no use at the script execution continues and the function mentioned in the setTimeout method will wake up after the specified interval of time. Thanks for the help. Pankaj

Is there a way to pause the script execution for a specified interval of time.

We have a requirement where we need to display, 3 type of information, which are not related to each other in such a way that the user is able to navigate(first page of the other section) to another set by clicking some link or something. We decided to acheive this in following way: 1. Create 3...

Hi, It does not work. From Package Properties -> Advanced tab, I set the "Use Transaction" and "Commit on successful package completion" options with the isolation level of "serializable", but still the changes are committed. Thanks, Pankaj

We have a table, which uses data binding to generate the contents of the table. Initially there will be one blak row in the table, which is acheived by binding to a blank xml string(xml schema is same but no values). Later on when the user does something we get the actual xml string and uses it...

I have a DTS package, which has some tasks. Each task is suppose to copy the data from an excel sheet to a table in the database. In case we encounter any error in the execution of any step all the data copied in the previous tasks in already populated. We want to commit the changes only when...

Thanks for your response. Actually we have developed a common component for the client, which has been used in several projects. We have been using early binding. but in one of our last projects where the application has to share the server with another server had an older version. Due to this...

I have a class which have lot of enum defined in it. This class along with other classes(have some functionality) have been packaged in a project and I have created a dll for the project. There is another project where I need to call different methods and need to access the different enumerated...

It worked like charm. Thanks for all the help. I future I will try to post the thanks regularly.