by: Caveman |
last post by:
-- I have a situation where doing
-- first example
-- 1. Get series of values througha query into a string (@val)like
'1,2,3,4':
declare @val varchar(4000)
select @Val = @val + cast(myval as...
|
by: Mike MacSween |
last post by:
This as the row source for a combo:
SELECT qryRole.RoleID, qryRole.Role
FROM qryRole
WHERE (((qryRole.RoleID) Not In (SELECT RoleID FROM qryRoleEvent INNER JOIN
qryEvent ON qryRoleEvent.EventID...
|
by: phillip.s.powell |
last post by:
update student s set school_year_id = (select distinct s.id from
school_year s, interns i where lower(s.school_year_name) =
lower(i.enrollment_year)and s.unique_key = i.unique_key group by s.id);...
|
by: abbaskhan |
last post by:
Actuall in this query i am trying to to compare the monthly change percentage
i ,e january 2007 aganest dec 2006 and the value is available in one table
and same column one below the other
when...
|
by: rishhh |
last post by:
The following query results no records. I am trying to exlude the Counter party Descriptions present in the Adjustments table, from the results of the main query. Any help is appreciated.
SELECT...
|
by: arunmen |
last post by:
Hi folks,
I have an situation like I have an table named Location where by it stores all
the details of location. In the table I have 2 columns State, city where by I have some duplicate values...
|
by: flushfire |
last post by:
i am trying to update a table with values from another table AND an independent value at the same time in a single query.
insert into table1 (column1, column2) values ((select column1 from...
|
by: javakid |
last post by:
Hi MySQL Gurus,
I have a query as in following format:
update tbl1, ( subquery )as tbl2
set tbl1.col1 = IFNULL(tbl2.col1,0)
where tbl1.col2 = tbl2.col2Here, Actually i am returning a...
|
by: antoine1987 |
last post by:
Hi
I am trying to run this code in order to fill the reasults in the column
update test
set activate = (select distinct
count(sigmessages.messagetype)
from
sigmessages
WHERE
|
by: kishorer |
last post by:
QUERY->
select *
from sttb_record_log
where table_name IN ('STTMS_CUSTOMER', 'STTM_CUSTOMER')
AND KEY_ID LIKE(SELECT '%' || CUSTOMER_NO || '%'
FROM STTM_CUSTOMER
...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
14
