Hi,
When you're in a loop inside a stored procedure, how do you break out of the loop?
Thank you.
I have the attached and SP code snippet which, when fed a VCHRNMBR variable, will return up to 4 rows. I need to design a WHILE Loop to combine the DistRef field from all the returned records...
I've exported a WordPress MySQL database using phpmyadmin, but the special characters in the database text, like é, ç and so on, have been changed into ASCII strings. This happens even with ce...
Here is the basic idea of what I am trying to do. I need to copy data from one column to another column in the same table if a condition is met in another table.
Update tbl1
Set tbl1...
Hi,
I have table Range as:
Status Range From Range To
OK 800 1000
Below 1 799
High ...
I have two select statements that each produce multiple columns of data and multiple rows. Each select statement produces the same number of columns and rows. I would like to produce one sel...
Hi,
I'm currently teaching myself sql server 2005. In laymans terms I am trying to find out the difference between : -
inner joins
left joins
right joins
Many Thanks
Lee
I need to add the day of the week name to my query below for timein_date. So that the date will display as Tuesday 8/28/2007. How can I add this to my query, I was close with a case statmen...
i am writing a select/ insert query where i want a value of a field different for different scenario.
i am using case for this purpose, but there apperas to be some error in the code.
i ha...
Working with SQL Server 2000. I'm trying to convert a date to a char or varchar to compare to another string. Ideally, I'd like to convert GET_DATE() and get the output: yyyymmdd (ie: 200707...
I want to copy the data of two columns from the record with an Enroll_ID of 1234 and paste it into the same columns for the record with an PRGM_ID of 2222. This first query here is only with ...
I would like to query the following based on the current date 07/29/2008
Start Date and End Date for Last Week (if current date is 07/29/2008, then between 07/20/2008 - 07/26/2008)
Start D...
I have a table:
data_table
subject year totaltested
I want to change this query:
SELECT
subject,
year
FORMAT(SUM(totaltested), 2) AS total,
FROM data_table
...
Hi everyone, i am trying to run the CREATE proceedure on SQLCMD and i have come accross a snagg.
The code is below.
-------
USE [MyDB]
GO
/****** Object: Table [dbo].[MyTable] Scrip...
Hi There
I have a string that comes through as follows
A24+B34.56* or sometimes comes through like this A24 or B34.78
I would like to check the string in my stored procedure.
If there...
Hi,
Like vb.net has the now command and vb6 has the date command has sql server 2005 got a function like this so I can place it in a stored proedure saving me passing the current date to th...
I have text field in my table. text value is in the format "Feb 20, 2007 22:57:36" how do I convert it to a datetime field for processing.
thanks
Hello all, I have three tables in MS Access that I want to join called...
Customer_Details, EMAS and work_orders
My current query
SELECT * from (Customer_Details
left join EMAS on C...
I wrote the code attached onload of form to handle NULL values.
While this works with a normall datagrid, it does not work for ComponentOne c1truedbgrid.
the default balues do get saved, how...
OK you T SQL query experts try this one out;
I have two tables;
1. "Vendors", containing 200 unique Vendors names [ varchar(30)] and matching Expense Codes [int(2)], 2. "Transactions", con...
I've got a table which contains a series of dates (the columns are client_id, start_date and end_date). I need to calculate the number of working days between the start and end dates. This cou...
I have a record set returned which returns the following sample dataset
"Select productid, class from product_class"
PRODUCT ID CLASS
001 A
001 ...
Hello
I hope someone can help me with this query. unfortunately this one's beyond my sql reporting skills!
Please see the attachment for an example of the table I want to report from. ...
Hello
This could be a simple task for some of you but I am finding it difficult to write a query for following task.
I am building a query using one variable and then I want to assign th...
Hi There
I would like to work out how many days there are for a particular date up until now.
I have a query that looks like this.
UPDATE TBL_FEESDATA
SET TBL_FEESDATA.RealDaysOs = DateDi...
