Search results for query: *

My company has multiple divisions. I'd like to give the client the option to run the report for the division of their choice based on a parameter. I'm really being lazy here and would like to write 1 report instead of 3. Thanks for your help Scott Programmer Analyst <{{><

I'm moving queries from Access to Sql server and one of them uses the First() command in the query. I can't seem to find an equivalent in T-Sql. Can someone help out? Thanks Scott Programmer Analyst <{{><

I'm currently reviewing infragistics, componentone and janus control suites. My main interest is for the grid control. Janus I really like the grid control but the documentation sucks and the forums are less than helpfull. All of the samples make use bound data controls which I don't plan on...

I have a usercontrol that contains a treeview. I have included in this control an imagelist. I have applied the imagelist to the treeview and in the designer the control looks like it should. When the control is placed on a form the images are not present. My first pass to fix this problem was...

We currently use a document management system(DMS) for our ISO documents. This application is stand alone and was purchased. I am currently developing an application that could benefit by using this DMS. I would like to "embed" this application into a winform. Now, I know that this probably...

We currently use a document management system(DMS) for our ISO documents. This application is stand alone and was purchased. I am currently developing an application that could benefit by using this DMS. I would like to "embed" this application into a winform. Now, I know that this probably...

What project management software do you use to keep track of delivery dates, milestones, or anything related to project you work on? Scott Programmer Analyst <{{><

I'm using the following query to pull the table name and created date for tables in a database. I would also like to display the number of records in each table. select sysobjects.name, crdate from sysobjects where name like 'tbl%' Here is the function I wrote but it didn't work....for...

I'm experiencing an error when running a dts package from a C# application. According to the event log the error is "EXCEPTION_ACCESS_VIOLATION". The error doesn't occur each time but maybe one or two times a day. The errors didn't start happening until last week. I know this is cliche but I've...

I'm experiencing an error when running a dts package from a C# application. According to the event log the error is "EXCEPTION_ACCESS_VIOLATION". The error doesn't occur each time but maybe one or two times a day. The errors didn't start happening until last week. I know this is cliche but I've...

We're currently going through a migration to a newer ERP system. Using the driver provided by the company, I've created many DTS packages to transfer data from the ERP box to Sql Server. As a test bed I created a database called test. During the creation of the DTS pkgs, I specified the...

I'm interested in creating a knowledge base for some help desk software I'm writing. Has anyone done anything like this before? I'm looking for tips....... Do I create a special keyword field and search for solutions that way? If so how do I determine what words from the problem are keywords...

My current application needs to retrieve files in a directory on our web server. The server is on our network but not in our domain (in the DMZ). I dont want to create a drive on the user's pc as they will need to know the username and password. Is there a way to impersonate a user only for...

I read the posts at thread183-731431, but I don't really understand the problem. I have a udf call fn_Split2 that accepts a INT. The function returns a table (key,value). I'm attempting to the do following: select distinct rl.Log_ID from tblReqLog rl inner join tblReqProd rp on rp.LogID =...

No matter which application is being used, the first time I make a connection to our Sql Server it's slow. Then each time after that is lightening fast. I'm using Sql Server Authentication. Scott Programmer Analyst <{{><

First off let me say that anyone who helps explain why this is happening will receive a star. I've got several classes(Publication and Ad). The publication class contains information about a trade magazine(name, issue date). The Ad class contains information about an Ad that is in a...

I've normalized the database as far as I feel comfortable doing. This application is tracking sales leads. I've got a table called Leads which stores information about the lead themself. Then I've got a table called Company. This is where I store the lead's company information. I've already...

I've got a query that will return the following results Name|Hobbies Bob | Biking Bob | Golfing Bob | Baseball Is there a way to return the following: Bob | Biking,Golfing,Baseball ? Scott Programmer Analyst <{{><

VB Dim foo as string = &quot;This is a sample &quot; & _ &quot;of line continuation&quot; How would I accomplish this in C#? I've tried just using (;) at the end of each line but I rcv and error. string foo; foo = &quot;This is a sample &quot;; &quot;of line...

Access shows the value of a column as .02658. When I export the table into a csv file, the value is truncated to .02. Is there anyway to fix this problem? Thanks Scott Programmer Analyst <{{><