Search results for query: *

Hello, I am querying some TPS files and trying to build a query using an isnull() function such as "Select isnull(fieldname, '') as myfield from unnamed" also is there a listing of Topspeed functions that can be used? thanks G George Oakes CEO & President COPS Software, Inc...

Use ODBC to communicate with the data George Oakes CEO & President COPS Software, Inc. www.cops2005.com Programmer & Developer .Net, WSS 3.0, SQL DBA Check out this awsome .Net Resource! http://www.learnvisualstudio.net

Thanks CajunCenturion, I had feeling that because it was an object the compiler was treating it differently than a string or other data type variable. George Oakes CEO & President COPS Software, Inc. www.cops2005.com Programmer & Developer .Net, WSS 3.0, SQL DBA Check out this awsome .Net...

I am looking at the subroutine, and he is actually passing in the Odt object ByVal, not ByRef, so that wouldn't even work then would it? George Oakes CEO & President COPS Software, Inc. www.cops2005.com Programmer & Developer .Net, WSS 3.0, SQL DBA Check out this awsome .Net Resource...

Hello all, I am having to do a code review on one of our contractors and ran across an interesting piece of code. The contractor created a datalayer and used sub routines instead of functions to return values. And my question is why would he do this and how does it differ from best practices...

I had thought of a table, but was hoping for a more Programatic way of doing this. As for leap years, the DATEADD function does take that into account. George Oakes CEO & President COPS Software, Inc. www.cops2005.com Programmer & Developer .Net, WSS 3.0, SQL DBA Check out this awsome...

...for 10 years, but going forward I will need to alter this code every year and add an addition where clause. Here is the query so far.... SELECT * FROM [WAMAIN] where DISPCODE = 'ACTW' And ((ADDTIME between DATEADD(dd,-37, getdate()) and DATEADD(dd,-30, getdate())) -- 30 days OR...

There are no other data components on the form simply the fields that are layed out on the page. All other formats display the data correctly. with one exception, in Excel the first line is blank(where the headers might be, but there are no headers in the report) the rest of the formats are...

Well its not only sent out as a CSV, others use the data for spreadsheets, and reporting elsewhere, so an SSRS report makes sense here. George Oakes CEO & President COPS Software, Inc. www.cops2005.com Programmer & Developer .Net, WSS 3.0, SQL DBA Check out this awsome .Net Resource...

I have an SSRS report, that returns data that we need to send to a main frame. The main frame will accept a CSV file, so we created a subscription to email the report in CSV format to the main frame. Problem is when the report runs, and the csv file is generated the first line of the report...

OK so this maybe a newbee question, so forgive me. I have a sharepoint list. the user needs to be able to enter a Date 1/1/2010 and a time 12:12:12 am I tried creating a date time column however the time shows up as a Hour, Minute widget and the minutes are in 5 minute increments. This wont...

I want to open an infopath form via URL with input parameters, when the form opens I would like to use the input parameter to query a secondary datasource and return values to populate part of the form. For instance I have an inventory control infopath form. A user on the website has a list of...

Yeah I knew that truncate was minimally logged, and deletes were logged with greater detail. the database is set to Simple recover mode how much does that affect the deletes vs the truncates? Thanks G George Oakes CEO & President COPS Software, Inc. www.cops2005.com Programmer & Developer...

...query (greatly reduced for the web, but in a sense this is what it does.) Begin transacation Truncate Table mytable Insert into mytable( Select * from oracledatabase where addtime > sysdate -90 ) if @@trancount >0 Commit transaction I was thinking that this is a very huge waste of...

never mind I figured it out.... select dbo.ProperCase(e.drivername) as [DriverName], Max(m.meterreading) as meterreading, Sum(f.fuelqty) as fuelqty, Sum(ftc.milesdriven) as milesdriven , (Sum(ftc.milesdriven) / Sum(f.fuelqty)) as MPG, e.groupid, e.unitid as [Unit Id], convert(datetime...

I have a query that calculates vehicle mileage based on the miles driven fuel qty etc. Listing the driver and othe info. Issue is the software that gathers the milage and fuel data has problems sometimes, and stops the pump before the vehicle is full. So the driver has to enter in new...

the only thing in the log file is this; Microsoft (R) SQL Server Execute Package Utility Version 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:51:00 PM Error: 2010-03-25 16:51:00.80 Code: 0xC0016016 Source: Description: Failed to...

I have created a ssis package that will look in a folder for xml files and import them into sql 2005. So I have a Foreach File Loop container. I set it to look at the specified folder, and save the fully qualified filename into a user variable called "filename" Inside the foreach loop...

Jaxtell, Thanks that did the trick. I was pretty sure you couldnt compare nulls either but for the life of me could not remember why, or how to get around it. Thanks again G George Oakes CEO & President COPS Software, Inc. www.cops2005.com Programmer & Developer .Net, WSS 3.0, SQL DBA Check...

Hello all, I am joining some tables together to produce a report. In one of the joins I am doing a left join and occasionaly that will not return data to my select query. I am trying to create a select case query that when the left join does not join a record to use the data in another field...