Recent content by tbailey922

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