Dear Experts
I have a sql sp_send_dbmail job which emails users an HTML email. The email contains an image which is held on our webserver. This images displays fine if the email is receiv...
I have a query that I need to execute to get the referrer of our clients. I want to group them by the referrer, but when I try to add a where clause to take out the blank referrals, it ignores...
I am working with VB.Net 2005, looking at an Access 2003 database. I am trying to run a Delete statement and I get error "No value given for one or more required parameters." on the Command.Ex...
Hi,
I have a query that's using an implicit join. I would like to group the results by JOB TYPE only, listing the associated LOCATION and NETWORK number, and COST sum based on JOB TYPE. In ...
I am trying to set up a few different queries based on a date field and have no idea how to do it. For example, I need to get a date 4 months before the date field. I also need to do 2 weeks...
I need to create a job to clean up some data every night. I need to do a select statement (that joins multiple tables) and then loop through each record and do an update to one of the related...
I have an Access table that I want to run a query on to find out the records taht have two separate fields that do not contain the same data.
I have something like thism, but can not get it...
I have a Union query that will not return duplicate records. If I run each select statement by itsel,f I get a record with a que_rpt_Schedule_s1.ID (first field) of 11605. In the union query ...
I have 2 tables with product reference codes that are then merged into one table column alias using the following statement...
SELECT CASE RefCode1 WHEN '' THEN RefCode2 ELSE RefCode1 END A...
I want to make a Sales table in SQL. I have an equipment table which shows the equipment available for hire, and also a table which shows the currently hired items and their due dates. I want ...
I am attempting to return all records (or selected records) from a table using a query that contains a conditional expression to pass criteria. The attached conditional expression is working i...
sql server 2000. I have tableA, with three columns. column1, column2, column3. I want to select unique rows, something like
select unique(column1 and column2) from table 1 where column3 = v...
Can someone please tell me how I can determine what user mode my database is in? (Example, single user)
Greetings Gurus,
I am working in T-sql (MS SQL server 2005)
I am trying to format a datetime field to display in MM/DD/YYYY format. Here is my current select statement;
select distinct...
How can I use SQL to clear the values of only a specific column in a table. I tried using:
DELETE column FROM table
but that still cleared the whole table.
Objective: Update table dbo_LEASEBUT4 based on a value in table dbo_LEASEBUT7
The following Syntax::
update dbo_LEASEBUT4 set dbo_LeaseBut4.leasid = (select dbo_LeaseBut7.leasid from dbo_Le...
I am trying to write a variable length random function in SQL to be used on SQL Server 2005.
here is what I have so far...
Here are the errors...
Msg 443, Level 16, State 15, Procedur...
I have 5 spreadsheets. 4 represent one very large table placed on 4 sheets. One is a small seperate table with 3K records and one field in common with the large table placed on 4 sheets.
...
I have a table with a composite key consisting of 2 columns "ProductID" and "Season". I just realised that this can't be a key as sometimes there needs to be rows with the same ProductID and S...
I have a table with this structure.
Table: Scores
Fields: Date (datetime), Score (int)
I want to get the 70th percentile of Score for each date.
P.S. I will be using VB.NET frontend,...
I'm trying to pull the same name field from two tables and then get the max:
SELECT Max(Modified) FROM SELECT Modified FROM Menus UNION ALL SELECT Modified FROM Commands
It's not work...
I use the following to create a 'list' for a combo-box on a form
SELECT Agency.AgencyID, Agency.Name, Agency.AgencyType, Agency.Abbreviation
FROM Agency WHERE (((Agency.AgencyType)="Adjus...
Hi Experts,
Can I use Split function in SQL statement?
I have values in myTblB.aFldInB as a combination of words and numbers with brackets. E.g. "abcdef (123456)". I want to trim the num...
hello,
How can I use stored procedure as a table.
Thanks
Hi all, I'm trying to use TVF function in Where clause with conjunction with Case statement.
In this scenario I'm getting an error:
"Subquery returned more than 1 value. This is not permitte...
