I need some SQL Syntax to set the "Must Change" attribute of a Login WITHOUT having to change the current password.
I know this will do it, but it simultaneously changes the password:
ALTE...
Hi all,
I am wondering if I can use a BETWEEN operator in a SQL statement for the following example?
This is similiar to reserving a hotel room, or something like that:
I want to return...
Can someone please help me to get this query to work.
SQL 2000 standard
Goal.
Display the amount of days an invoice is overdue by.
If it is not overdue then leave it blank.
SELECT i...
Hi experts,
i added a return value to the parameters of an SQL Update query. I added it as the first parameter (as supposed to). I execute the update query in a stored procedure. All that w...
We are trying to find a SQL command that will help us find the table structure of a database. We are talking about 200+ tables on a database. We will be converting from SQL Server to Oracle.
Creating a query over 2 tables. Both have date fields and I'm summing 2 columns on each of them
I want the query to return
YEAR SUM(ADJ LOSS ADDITION) SUM(ADJ LAE ADDITIONS) SUM(EXP ...
Hello Experts, could someone please tell me how to find a trigger definition in sql server 2000. I am aware of how to find the trigger by running a select statement against sysobjects, but I ...
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.
Greetings Experts,
I am having a problem writing a query that joins 2 tables on 2 fields (no unique fields available) AND I also want to calulate the sum of individual fields after the tab...
Hi,
I am using MSSQL 2000
I have query written by someone
In the query, If I comment any of the below lines from the query
ON OrderItemsPicked.OrderLineID = OrderLine_1.id
ON Pr...
I have a list of checkbox values that I need to insert into a table. Is there a way to send a list to a stored procedure and then loop over the values to do an insert?
I need to work out the number of working days between two dates (i.e. excluding Saturdays and Sundays) that are stored in a table.
I've found two ways to this, and have attached the sql for...
I have a MS Access 2003 database that contains several fields as such:
Start_Date Start_time Actual_date Actual_time
20080315 19:00 20080315 18:4...
is there anyway to undo my last update statment?
i have just run an update statement but being the clown i am i left the where clause off so have updated every damn row.
plase tell me th...
Suppose I have a table called Products with the following fields
ProductID (VARCHAR(20))
Cost (DOUBLE)
and a table called ProductComponents with the following fields
ComponentID (VAR...
None of these solutions seem to work. Here are my table descriptions and data, with the fields separated by commas:
EMPS TABLE --> EMP_ID (int), EMP_FIRST_NM (nvarchar(50))
1, 'Yvonne'
2...
Hi Experts,
I'm looking for a function to count occurences of a word / substring in a string...
I have seen this - http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/counting-occurr...
Hi everyone,
Where can I download Brio Query Trial version?
Thank you
Can anyone help me in writing a SQL query which takes values from the list box and inserts into a database table.The only complication in this is
The number of items in the listbox may not ...
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...
I would like to use the DatePart function to indicate which quarter a date resides within a given fiscal year. As a default, the function does this calculation on a calendar year. Assuming ...
I have two SQL statements that I need to combine into one but I don't know the proper syntax.
The 2 statements are as follows:
Query1:
SELECT User, Sum(Miles) AS TotalMiles
FROM mytabl...
I've got two queries that I want to combine into one:
SELECT LogDay, Visits FROM vwNumVisitsByDay WHERE LogYear = 2007 AND LogMonth = 2 ORDER BY LogDay
SELECT LogDay, Pages FROM vwNumPages...
hi everyone,
i have a report which gives me a format like
BRANCH TENDER_DESC MONDAY TUESDAY WED THRUS FRI SAT SUN
what i want is to get this to columns
like
BRANCH TENDER_DESC MOND...
I currently have an access database with a query that I need to tweak. The existing query is:
SELECT ssUsers.custom1 AS Location, Sum(DateDiff("d",[CheckIn],[CheckOut])*[rooms]) AS ActualR...
