Search results for query: *

I have 3-tab tab control with a variety of combo boxes and a datagrid. When the user selects a different tab, I need the same combo box, datagrid, etc to remain on the next tab. The only thing changing is the datasource behind my dataset. The weird things is that the form was working...

I have about 10 queries that I run based on what the user selects in a listbox. Those 10 queries can be put into 1 of 3 catagories: LP1, LP2 and LP3. Each catagory has a different number of columns. For example, I run a query that is in cat LP1 which may have 4 columns. I then select another...

I have a group of results in a sql database (in one table named [zz_Results Master]. This table has mulitple colums - in particular [Set] and [Type]. The set is a user defined name that describes a set of sql queries. The type describes what type of queries were run. So for example, I will...

I am having trouble resetting the connection string to my master server. I have a dialog box that defaults the server and database to local and sa respectively. When the user selects refresh, I populate all the of the attached databases and display them in a combo box. The problem is that when...

I am building an application that requries the user to login to one specified instanct of sql server. I am using VB.net to create the application. What I want to have is a login that allows the user to select one of many possible instances of sql server on his/her machine or across a network...

Is it possible to have the follow? (CASE when [AcctTIV] = 0 or case when [BLANLIMAMT] = 0 THEN 0 ELSE [StateTIV]/[AcctTIV]*[BLANLIMAMT] END) AS ProRata Or is this the only way? (CASE when [AcctTIV] = 0 THEN case when [BLANLIMAMT] = 0 THEN 0 ELSE [StateTIV]/[AcctTIV]*[BLANLIMAMT] END...

I am converting a Access database into VB.Net and when writing the SQL, I have queries based on queries based on more queries. (Below is an example). What is the best way to increase efficiency when using nested queries? Esp. ones that I use often. Query 1 (__Accounts) SELECT...

We start off with a form that allows the user to select the database which resides on a SQL Server, Portfolio within the database, Peril, Country and State. These selections are used to create specific tables needed to run additional queries. After these selections are made, I then allow the...