Search results for query: *

I'm sure this is a basic question but if I have weekly recurring project meetings with x number of resource attending each meeting, and that meeting task duration is 1 hour how do I get prject to allocate one billable hourly rate for each attending resource? Currently it is dividing up the...

OK, I thought this forum was to get constructive help , not simply pick on your code. So far two responses neither of which even try to address the issue. I have no problem changing code if it speaks to the issue at hand but this code, old or not does work in .NET

I am getting the error on the following line myfile.Writeline(mystr) Also I only threw that on err statement for debugging.

Trying to write a simple data file out from a database table but keep getting 91 object variable or with block variable not set error. Any idea's ? Imports System.Data.Odbc Module MainModule Public Sub Main() Dim mystr As String Dim dbconn As New OdbcConnection...

Trying to write a simple data file out from a database table but keep getting 91 object variable or with block variable not set error. Any idea's ? Imports System.Data.Odbc Module MainModule Public Sub Main() Dim mystr As String Dim dbconn As New OdbcConnection...

Trying to write a simple data file out from a database table but keep getting 91 object variable or with block variable not set error. Any idea's ? Imports System.Data.Odbc Module MainModule Public Sub Main() Dim mystr As String Dim dbconn As New OdbcConnection...

I need to insert records from an Excel sheet into a temp table in SQL without using DTS. I have tried the following: Select * into NelNet_tmp FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=B:\MIS\MIS\Extracts\NelNet\MIPRIV 1282005(2).xls;HDR=YES', 'SELECT * FROM [Report1]')...

Still get a save as prompt using this command.

I am running this module as a stand alone .exe to auto refresh an excel file. The problem is how do I avoid the save prompt from appearing to make it fully automatic? Public Sub ExcelRefresh() Set objExcel = New Excel.Application objExcel.Visible = False objExcel.DisplayAlerts =...

Yes I want to ignore the time and only bring in the date

I am trying to import date data in the following format into a datetime field using DTS and the DateTimeString transformation tool to do it. However when ever it hits an hour field > 12 it throws a conversion error: The raw data looks like this: 20050522142901 Source data format used...

I have pub 97 installled but have several pub 2003 version .pub files I need to open. 97 won't let me open these files as they are a different version. Is there any way I can convert these files or find a way to open using only publisher 97? Thanks.

That code worked , I was tring to cast the char field instead of the else result field. Thanks.

I am having trouble with the following statement: select top 100 [decision_score], case when [decision_score] between 620 and 639 then '620-639' else [decision_score] end as ScoreBand from tblCMSImain where [initiation date] > '01/01/04' Getting error: Server: Msg 245, Level 16...

Nope, I am looking for the minimum(or first) value the and the max(or second) value tied to the acct_num field.

I have two tables where I need to update from one into the other . The table I am updating contains account numbers which is the primary key. The table I am getting the data from also has an account number that ties to the first table. The field I need however can contain two values for...

I need to export a table, via a dts pkg that will run daily, from one server to another that are connected through a complany WAN. I have not done this before and am looking for help on how to set this up.

Does anyone know where DTS packages and Scheduled jobs are stored? I need to attempt to recover these pkg's and jobs after a server rebuild . Thanks.

I have found two reports in my db that are nameed ~tmp followed by some letters and numbers. I need to delete these reports. Repair DB did not work. They do not show up in the reports window. Also when I go into the sysobjects table, I cant delete them due to a "no delete permission on...

I am looking for the easiest way to get a listing of all of the tables and fields within a databaes. Is there a sp or something that will do this? Thanks.