Search results for query: *

I still the same error. Still dazed and confused!

Hello, Does anybody know to execute a dts package from a stored procedure. Or maybe tell me why I am getting this error. From QA I execute: exec master..xp_cmdshell 'DTSRun /S "INTRANET" /U "test" /P "bailey33" /N "exporttoexcel" /V "{E60BEDE0-654A-489A-B755-9835D221A100}" ' I get the...

Hello, How you declare variables to use with a SQL Server stored procedure? I am performing some calculations and need to return the results to a variable, and do some other calculations on that variable. Also can you pass variables from vb.net to a stored procedure? Thanks Tim

Hello, Does anybody know how to run a DTS package that is created in SQL Server. I want to transfer data from one table to another when the user hits a button. Program was written in VB.net. Thanks Tim

I did exactly what you said and now I get an Error called Exception from HRESULT: Any ideas? Here is my code: Const sSampleFolder = "C:\ExcelData\" 'Create a new workbook in Excel. Dim oExcel As Object Dim oBook As Object Dim oSheet As Object...

Hello, Is there a way to export to excel 2000. I need to do it using SQL Server and I can't seem to find any example using SQL Server. Here is my current code I got off the Microsoft Knowledge Base: Const sSampleFolder = "C:\ExcelData\" Const sNorthwind = "C:\Northwind.mdb"...

You make a vailid point Redlam it would grab the first record in the table and that would be the dept and jobdesc, I guess I am so used to it doing this. It is a big change for it not to do it. Thanks Tim

Sorry for not giving an example. Here is part of my code. "select job, subjob, dept, jobdesc,SUM(selling) AS complsalesprice, SUM(actualcost + costtogo) AS complcost, SUM(actualcost) AS currentcost from jcpmst group by job, subjob, dept, jobdesc order by job, subjob" I only want to group...

Hello, I just can't believe the group by function in SQL Server. I am trying to grab some data from a table and group by only the first two columns, but in SQL you have to group by each column for the whole table. Which throws off the whole grouping. In foxpro you could select the whole...

Hello, I am selecting two columns from a table and grouping on those two columns. I want to put them into a temporary table so I can join that temp table to another table. My question is how do I create a temp table and insert my results to it. Here is what I got so far: Create table #tempp...

Hello, I am using vb.net and cr 9. In my report I filter my data by prompting for a parameter (discret value). I was wondering if there was a way to filter my data by having the user selecting the jobnumber on a form and hitting a button that will show the report without prompting for the...

Thanks for the fast response, works great.

Hello, I'm sure this can be done but I can't seem to figure it out. In a table I have a field called job and another called subjob. I want to add them together to get one field but also I want to put a "-" between the job and subjob. It should look like this 100356-125. I am using vb.net...

Thanks for the help and reply. Tim

Hello, Does anybody know how to add two fields together in a foxpro table? What I have in one table is areacode in one field and the phonenumber in another field. I want to add these fields together to make one field with areacode + phonenumber as one. Thanks Tim

Thanks for the help. Tim

Hello, I have a crystal report that is developed in VB.Net and am having trouble with the layout. I set my report to be 11 inches wide (landscape) and in design view it looks fine. But when I run the report it defaults to portrait view cutting off some information on my report. Has anybody...

On the remote pc there is no sql server installed. It is just a vb.net program with a connection string pointing to the sql server on the company network over vpn. Thanks Tim

Hello, This has me stumped and I can't seem to figure it out. I created a vb.net project and it connects to a sql server. It all works fine inside the company network but when I try to run the program from home over vpn it says it can't find the sql server. Here is my connection string...

Hello, I was wondering if there was a way to get a user's network id. Not the PC login name but the actual network one. On this program I am doing when I install the program on Win98 users they have no login name and the program bombs, It works fine with Win 2000 though. Thanks Tim