This is my Sql statement which appears on a datareport in vb6. In the database, paymentmethodID is formatted as a number, yet it appears in the database as a string not a number. So when I ad...
hi guys i have a query which is fine and give me results but i want to ROUND some of them so that i dont get long zero's in my VALUE/CUM VALUE/ROS etc how can i do it
This is part of a larger solution where I need to create nested cursors to copy data about a site, it's pages, content regions associated with each page, the content of specific regions, and U...
I have an extensive search page (ASP/SQL Server) which uses similar code to this - with many optional search parameters. I am trying to use only stored procedures to prevent sql injection atta...
Hi,
What do I need to do to the following Access code to convert to using SQL Server 2005?. I have got so far but am now stuck with the INSERT statement parameters & on adding the current...
I want to update the values in one table based on the city they are in which is located in another table. When I try to join the tables in my update command I get the following error message:...
Ok so I have a sql statement that is returning some data that is being populated by 2 systems. One system uses user2ent field to show who entered the data and the other system is using buyeri...
I have a table that contains the following:
BookingID int (unique)
Employee vachar(200)
Facility varchar(200)
.
.
Total decimal(10,2)
I want to go through this table and put all of ...
hI,
I have the following line of code in a VB6 project
SQLStmt = " INSERT INTO Recipes_West_Table " & _
"Values( " & Form1.Text1.Text & " , " Form1.txtVal1.Text & "," & Label2.Caption...
The following gets the first date of the current quarter:
TRUNC(sysdate,'Q')
is there a way to get the last day?
I always want to Round UP no matter what decimal is returned. Example: 369.2 will be 370 just like 369.7 will be 370.
I am writing a SPROC. What is the syntax for converting the result of GetDate() into the format yyyy-mm-dd hhmm?
DECLARE @MyDateTime varchar(20)
@MyDateTime = GetDate()
REF is a Text field in Table1
In Query1 - Calculated field --- > Test_Field: IIf([REF]="K","other",IIf(CInt([REF])=1,"One",IIf(CInt([REF])=7,"Seven",IIf(CInt([REF])=12,"Twelve",IIf(CInt([REF]...
I need to print to a log printer as a redundant fail-safe for a sports scoring application. I would like to print the values of several fields each time an insert occurs. I already have a tr...
Below is the data set which I currently have by querying
UNIT NODE TYPE ACCOUNT SEQ
AA AB1 CON 677 1
AA AB1 ZBA 523 1
AA AB1 ZBA 504 1
AA AB1 STAND 555 2
AA AC1 CON 876 1
AA AC1 ZBA 4...
I need help creating columns for the number of days since an order has been place, I cannot figure out how to code the query for the number of days since the order has been place. Ex: I have 3...
Hello,
I can a vendor stored procedure that displays data after it runs. I would like to capture that data and have Database Mail send me those data. I've made some attempts to configure it b...
I added a field to an exist View in a SQL2005 database. The data definition of the Source Column is FLOAT. In the view, the new column was added as INT.
I updated a Crystal report to use ...
This is probably a very simple question...
I would like to know how to create a dynamic Stored procedure that will return anything I ask..
like...
CREATE PROCEDURE usp_ReturnTemplated...
MYSQL
Mind to show me some example on How to create simple FUNCTION SQL and DO FUNCTION CALL and show result if can
Also can you explain abit why we need to use FUNCTION SQL?
I am using SQL Server 2000 and I have created a user defined function named TT_GET_MARKUP2. The select statement of the function works in Microsoft's SQL Query Analyzer, but when I try to cre...
I have a trigger shown in the snippet,
It inserts the records in opdetm joined by opheadm.order_no = opdetm.order_no, into opdetm_audit when opheadm's status is updated to 9,
what i wa...
How can a pass an SQL text greater than 255 characters that has been stored in a table to the SQL property of a QueryDef?
In many words:
I have a table where I store the SQL to generate a ...
I can't figure out the syntax for DROP and CREATE statement in a SQL Server 2005 Stored Procedure.
I want to store the Stored Procedure in another location so that when I EXECUTE it in a ne...
How can i convert UTC timestamp to GMT in php?
I have a MySQL field that saves the time with UTC_TIMESTAMP() in the INSERT command. When I pull up the record, how can i convert that time t...
