Search results for query: *

Problem "Syntax error converting datetime from character string." I know what this means and I even know the exact record causing this problem. What I can't figure out is why I am getting this error. Details The linecode is a char field but the application that populates it defaults it to a...

It has become apparent to me that you can't use dynamic parameters in regular subscriptions. Example: =DateAdd("d",(-1*Day(today())), today()) [silly question] Will the vbscript execute for the dynamic parameter if it is a default value? [/silly question] I just need a quick and dirty...

I basically have a table that has multiple columns to hold data for transactions but it really boils down to two columns. A license number(char(48)) and a status code(char(2)). A license number goes through multiple status codes as it flows through the system with a new line for each. What I...

I have some triggers on two tables in an application database in our dev environment. The triggers are used to track changes to certain fields on those tables for compliance and audit reports. Long story short it appears that the triggers are causing the application to have an error when an...

Anyone in here have any links or know where I can read up on the differences between derived tables, views and table variables. I am more concerned with performance issues and I am pretty sure it comes down to the anticipated size of the data and what kind of machine it is on, but I would just...

This issue has me so confused. When I run the underlying query/procedure from Query Analyzer it executes fine. When I try and execute the report then the CPU resources jump and so does the memory. After a while the report request times out and CPU drops but the memory still stays high. The...

I have several questions about views as I am unclear on them at the moment. A. When a view is created is that view just a snapshot virtual table of the data or is the information in the view updated when changes are made? Example: I create a view that holds payments from several different...

When I try and sign a PDF I get the following error. Error: The document could not be signed. Unable to open file for writing. It may be locked or unavailable. What causes this and is there a way to fix it. I am getting the PDF files from another person...

What is this error? I get it when I run an SP that does 1 of 2 queries based on if the user has input information or not. I have several other SP like this but this is the only one that gives me errors. It does not give me an error when I have selection criteria only when its nothing to select...

I have a job that is broken down in multiple steps. It works but randomly one of the steps will fail. This is a step where I query the database itself. I applied the hotfix that was supposed to fix the job scheduler not releasing processes. that helped my cpu resources but I notice memory...

Hello I am trying to design a query that selects data from multiple tables. I have run into a snag as one of the possible conditions of the select statement pulls from a seperate table. Here is an example of what I am doing. Assume the variables have already been declared. Select ID, Name...

I have a query that seems rather simple but is giving me trouble. Table A contains orders details including but not limited to order date vendor # order cost What I am trying to do is get a list with the sum of the order cost for each specific vendor within a givin date. The output is either...

I have something similar to this. declare @last_date_read smalldatetime select @last_date_read = max(date_time) from database_A SELECT somestuff..., [time], date, more stuff FROM OPENQUERY(somelinkedserver,'Select * from databaseB) WHERE CONVERT(smalldatetime, (date+' '+[time in]))>...

I have a procedure that has to run every minute. It queries data based on the time among other things. In case an error occurs in operation of the procedure and a minute or two (or more) get skipped i need to get the data within the time frame that execution failed. Is there a way to pass...

For a paradox database on one machine, to be a linked server in sql 2000 on another machine across the network. Is this possible. I am getting all sorts of errors from "7399 MSDASQL reported an error." to "ODBC connection errors". ======================================= The statement below...

I have the following statement in Query analyzer [code] declare @file_name varchar(255) declare @current_date_time varchar(255) select @current_date_time = REPLACE(CAST(GETDATE() as VARCHAR),' ','_') set @file_name = 'C:\'+ @current_date_time + '.txt' select @file_name as 'filename'...

I need to BCP a table into a text file for use by others. This is normally simple but I can't BCP the whole table, just the results of a query based on a few things. I am sure it is something simple. I need to know two things 1. Is it possible to BCP the results of a query and if it is how to...

I am confused as to the operations of postback, viewstate and session state. Is a link or FAQ available that explains in depth about these things. As it is my page is acting funny capturing data from controls and i believe the problem is me not properly understanding the functions of these...

Can someone tell me or send me to a site that will explain in detail what autopostback and states are. As it is all it seems that postback does is reload a webpage which is really annoying and is messing up the way i want this page to work. The statement below is true The statement above is...

Im relatively new to .Net. I wrote a class/classes in C# but i want to try and use them in VB.net. When i added the class to my project i get the underlined squiggly line indicating an error. How do i go about using my class in VB. If cats always land on their feet and Toast always lands...