473,574 Members | 3,097 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Query: union on self

Hello every body.

I have a small issue.

Problem: I have a table with 4 descriptor columns (type). I need to
formulate a query to retrieve a count for each type so I can group
by...etc. The view I have works, but doesn't work when I supplement the
query with some functions... they just don't like the UNION. The real
problem is I can't change any of the udf's or queries, just the view.
The view is inner joined back on to the primary table 'qt_ins' again
and a heap of other tables. But for this post and to not complicate it
too much I've just included the primary table and the view...
Also my querys work if I don't put a where clause on for the VIEW. eg:
.... and cv.type = 'Environmental' .... for some reason with a clause it
gets stuck in an *infinite loop.
Conditions: The table structure cannot be changed in anyway. The
view/query must return 2 columns qi_id & type.

I considered creating a function to return the Types but then I figured
I would ask you folks for a better way.

Any help with the view appreciated.

Thank you.

The below will create the table, with sample data and the view.

---------------------------Start
Query--------------------------------------------
CREATE TABLE [dbo].[qt_ins] (
[qi_id] [int] NOT NULL ,
[qi_injury] [bit] NULL ,
[qi_environmenta l] [bit] NULL ,
[qi_equipment_da mage] [bit] NULL ,
[qi_vehicle] [bit] NULL
) ON [PRIMARY]
GO

INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (20,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (21,0,1,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (23,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (24,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (25,1,1,1,1)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (26,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (27,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (28,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (29,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (30,1,1,1,1)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (31,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (32,1,1,1,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (33,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (34,1,1,1,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (35,1,0,0,1)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (36,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (37,0,0,0,1)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (38,0,0,0,1)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (39,0,1,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (40,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (41,0,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (42,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (43,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (44,0,1,1,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (45,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (46,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (47,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (48,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (49,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (50,1,0,1,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (51,0,0,1,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (52,0,1,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (53,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (54,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (55,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (56,1,1,1,1)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (57,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (58,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (59,0,1,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (60,0,1,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (61,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (62,0,1,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (63,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (64,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (65,1,0,1,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (66,1,0,0,1)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (67,1,1,1,1)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (68,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (69,1,0,0,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (70,1,1,1,1)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (71,1,1,1,1)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (72,1,1,1,1)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (73,0,0,1,0)
INSERT INTO qt_ins
(qi_id,qi_injur y,qi_environmen tal,qi_equipmen t_damage,qi_veh icle)
VALUES (81,1,0,0,0)
GO
CREATE VIEW dbo.v_qt_in_typ e
AS
SELECT qi_id, 'Injury' AS type FROM qt_ins WHERE qi_injury = 1
UNION all
SELECT qi_id, 'Environmental' AS type FROM qt_ins WHERE
qi_environmenta l = 1
UNION all
SELECT qi_id, 'Equipment damage' AS type FROM qt_ins WHERE
qi_equipment_da mage = 1
UNION all
SELECT qi_id, 'Vehicle' AS type FROM qt_ins WHERE qi_vehicle = 1
GO

select count(*),type from v_qt_in_type group by type
---------------------------END
QUERY--------------------------------------

Jul 10 '06 #1
7 3306
KoliPoki (ra****@gmail.c om) writes:
Problem: I have a table with 4 descriptor columns (type). I need to
formulate a query to retrieve a count for each type so I can group
by...etc. The view I have works, but doesn't work when I supplement the
query with some functions... they just don't like the UNION. The real
problem is I can't change any of the udf's or queries, just the view.
The view is inner joined back on to the primary table 'qt_ins' again
and a heap of other tables. But for this post and to not complicate it
too much I've just included the primary table and the view...
Also my querys work if I don't put a where clause on for the VIEW. eg:
... and cv.type = 'Environmental' .... for some reason with a clause it
gets stuck in an *infinite loop.
I'm afraid that it's impossible to assist with the information you have
given. First you say "don't like the UNION", which indicates that you
have some trivial syntax error. Then you talk about infinite loops,
which indicates that the query runs for a very long time.

You posted a repro, which is great. Unfortunately, that repro appears to
work without any problems. If you instead post a repro that demonstrates
the problem, it's a lot easier to say what is going on.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 10 '06 #2
Erland, thank you for your reply.

That's correct the UNION doesn't work with my query.
Unfortunately it's very hard to give you all the code as there are 3
functions and another 12 tables, 2 with hierarchical
(parent/child/lineage) data (Business units, Job titles).

There are no syntax errors, the problem is that my query never
returns... like it's stuck in a loop. If I remove the union like:
-----------------------------------------------
CREATE VIEW dbo.v_qt_in_typ e
AS
SELECT qi_id, 'Environmental' AS type FROM qt_ins WHERE
qi_environmenta l = 1
-------------------------------------------------
it works fine and fast, but is obviously incorrect as it only returns
records of 1 type.
So the problem is....

Can any one think of another way to write the below query without the
UNION

---------------Query to write in a different way---------------

SELECT qi_id, 'Injury' AS type FROM qt_ins WHERE qi_injury = 1
UNION all
SELECT qi_id, 'Environmental' AS type FROM qt_ins WHERE
qi_environmenta l = 1
UNION all
SELECT qi_id, 'Equipment damage' AS type FROM qt_ins WHERE
qi_equipment_da mage = 1
UNION all
SELECT qi_id, 'Vehicle' AS type FROM qt_ins WHERE qi_vehicle = 1

------------------------END QUERY-------------------------------------

Thanks for your help, and apologies for not being able to provider the
full context of the issue.

R.

Erland Sommarskog wrote:
KoliPoki (ra****@gmail.c om) writes:
Problem: I have a table with 4 descriptor columns (type). I need to
formulate a query to retrieve a count for each type so I can group
by...etc. The view I have works, but doesn't work when I supplement the
query with some functions... they just don't like the UNION. The real
problem is I can't change any of the udf's or queries, just the view.
The view is inner joined back on to the primary table 'qt_ins' again
and a heap of other tables. But for this post and to not complicate it
too much I've just included the primary table and the view...
Also my querys work if I don't put a where clause on for the VIEW. eg:
... and cv.type = 'Environmental' .... for some reason with a clause it
gets stuck in an *infinite loop.

I'm afraid that it's impossible to assist with the information you have
given. First you say "don't like the UNION", which indicates that you
have some trivial syntax error. Then you talk about infinite loops,
which indicates that the query runs for a very long time.

You posted a repro, which is great. Unfortunately, that repro appears to
work without any problems. If you instead post a repro that demonstrates
the problem, it's a lot easier to say what is going on.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 10 '06 #3
You can try something like this:

SELECT qi_id,
case
when qi_injury = 1 then 'Injury'
when qi_environmenta l = 1 then 'environmental'
when qi_Equipment damage = 1 then 'Equipment damage'
when qi_Vehicle = 1 then 'Vehicle'
end
AS type
FROM qt_ins
WHERE (qi_injury = 1) or (qi_environment al = 1 ) or
(qi_equipment_d amage = 1)
or (qi_vehicle = 1)

But it would be interesting to see why is your original query slow. Any
additional infotrmation?

Jul 11 '06 #4
KoliPoki wrote:
Erland, thank you for your reply.

That's correct the UNION doesn't work with my query.
Unfortunately it's very hard to give you all the code as there are 3
functions and another 12 tables, 2 with hierarchical
(parent/child/lineage) data (Business units, Job titles).

There are no syntax errors, the problem is that my query never
returns... like it's stuck in a loop. If I remove the union like:
-----------------------------------------------
CREATE VIEW dbo.v_qt_in_typ e
AS
SELECT qi_id, 'Environmental' AS type FROM qt_ins WHERE
qi_environmenta l = 1
-------------------------------------------------
it works fine and fast, but is obviously incorrect as it only returns
records of 1 type.
So the problem is....

Can any one think of another way to write the below query without the
UNION

---------------Query to write in a different way---------------

SELECT qi_id, 'Injury' AS type FROM qt_ins WHERE qi_injury = 1
UNION all
SELECT qi_id, 'Environmental' AS type FROM qt_ins WHERE
qi_environmenta l = 1
UNION all
SELECT qi_id, 'Equipment damage' AS type FROM qt_ins WHERE
qi_equipment_da mage = 1
UNION all
SELECT qi_id, 'Vehicle' AS type FROM qt_ins WHERE qi_vehicle = 1

------------------------END QUERY-------------------------------------

Thanks for your help, and apologies for not being able to provider the
full context of the issue.
Alexander has given what I think is a pretty good solution to this. To
the original problem though, did you get a query plan for the select
statement that ran for so long? What was the query plan doing?

One thing to keep in mind is that if you are using UDFs, they can often
dramatically impact a querie's performance. It's impossible to know
without your data and the full table, UDF, and view SQL code, but maybe
when you use the UNION with the UDF it has to actually select the
entire dataset, applying the UDF to each row and then performing the
UNION operations before it is able to filter out rows based on your
WHERE clause criteria. I'm afraid that I don't know how smart SQL
Server is when you do a union like this within a view and then select
from the view based on a column that is calculated within the view.
Even if the UDF has nothing to do with it, it may be that when you
select WHERE qi_environmenta l = 1 then SQL Server can use an index, but
when you have a column hard-coded the way that you do in the unions it
can no longer use that index when you do WHERE type = 'Environmental' .

Anyway, just some stuff to look into for you.

-Tom.

Jul 11 '06 #5
Alexander Kuznetsov wrote:
You can try something like this:

SELECT qi_id,
case
when qi_injury = 1 then 'Injury'
when qi_environmenta l = 1 then 'environmental'
when qi_Equipment damage = 1 then 'Equipment damage'
when qi_Vehicle = 1 then 'Vehicle'
end
AS type
FROM qt_ins
WHERE (qi_injury = 1) or (qi_environment al = 1 ) or
(qi_equipment_d amage = 1)
or (qi_vehicle = 1)

But it would be interesting to see why is your original query slow. Any
additional infotrmation?
I just posted that this was a good solution in another post, but now it
occurs to me that it will not return the same resultset as the original
poster's solution. The query above will return only one row per qi_id,
but the original solution could return up to four for each qi_id.

-Tom.

Jul 11 '06 #6
Thomas,

thanks for the correction. Untested again, no DDL, no DML!

SELECT qi_id, t.c AS type
FROM qt_ins join
(
select 1 n, 'Injury' c
union all
select 2 n, 'environmental' c
union all
select 3 n, 'Equipment damage' c
union all
select 4 n, 'Vehicle' c
) t
on (qi_injury = 1 and t.n=1) or (qi_environment al = 1 and t.n=2) or
(qi_equipment_d amage = 1 and t.n=3)
or (qi_vehicle = 1 and t.n=4)

Jul 11 '06 #7
Thanks Folks.

I was dubious of using a derived table, as I had already tried wrapping
some of the logic in derived table and it didn't work, but I never
tried using a derived table for the view...guess what, it work!

Why, I'm still not sure.

The query was never returning when the view and a function were used in
the clause of the query.

Example of not working:
select qi_id, .....
from qt_ins q
inner join v_qt_in_type v on q.qu_id = v.qi_id
inner join ...
inner join ...
....
where
..... and
q.qi_mr_emp_no in(select emp_no from udf_qi_my_subor dinates('49549' ))
and
q.qi_observatio n_date>=dateadd (yy,-1,current_times tamp) and
v.type = 'Environmental' and
dbo.udf_qi_em_r eturn_above_rep ortsto2_1(q.qi_ mr_emp_no,'4954 9') = 'GM
OH&S'
But would return if either
dbo.udf_qi_em_r eturn_above_rep ortsto2_1(q.qi_ mr_emp_no,'4954 9') = 'GM
OH&S' or v.type = 'Environmental' was removed it would work even if
they were referenced the select string.

Example working:
select qi_id, .....
from qt_ins q
inner join v_qt_in_type v on q.qu_id = v.qi_id
inner join ...
inner join ...
....
where
..... and
q.qi_mr_emp_no in(select emp_no from udf_qi_my_subor dinates('49549' ))
and
q.qi_observatio n_date>=dateadd (yy,-1,current_times tamp) and
--v.type = 'Environmental' and
dbo.udf_qi_em_r eturn_above_rep ortsto2_1(q.qi_ mr_emp_no,'4954 9') = 'GM
OH&S'

Thanks Alexander for your help.
Alexander Kuznetsov wrote:
Thomas,

thanks for the correction. Untested again, no DDL, no DML!

SELECT qi_id, t.c AS type
FROM qt_ins join
(
select 1 n, 'Injury' c
union all
select 2 n, 'environmental' c
union all
select 3 n, 'Equipment damage' c
union all
select 4 n, 'Vehicle' c
) t
on (qi_injury = 1 and t.n=1) or (qi_environment al = 1 and t.n=2) or
(qi_equipment_d amage = 1 and t.n=3)
or (qi_vehicle = 1 and t.n=4)
Jul 12 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
8223
by: Wiebke Pätzold | last post by:
import sys Hi all, At the beginning there is a table (database) with different columns. So I create a search operator to look for regular expressions. First I start the search only in one column and the program run. Now I want to expand the search. The search have to take place in 2 columns. In my example it is "Themenbereiche" and...
4
1733
by: techquest | last post by:
got slightly similar table. #Temp Table: name,name1,name2,exam,score A,A1,A21, A,A1,A21,math100,88 A,A1,A21,math101,56 A,A1,A21, A,A1,A21,math102,67 A,A1,A21, A,A1,A21,math104,45
3
3553
by: Paradigm | last post by:
I am using Access 2K as a front end to a MYSQL database. I am trying to run a Union query on the MYSQL database. The query is (much simplified) SELECT as ID from faxdata UNION SELECT as ID from letdata UNION SELECT as ID FROM MEMODATA; I get an ODBC error. The same query runs when the backend files are MDB files and it runs with...
3
6152
by: Richard Williamson | last post by:
Hi all, I have managed, using a quite tortuous route, to select certain records in a UNION query. This is based on the results of other queries. Question: how the devil do I change the value of a field in these, and only these, records? I have tried an update query and VBA all without success. I know help says that you can't change the...
2
3565
by: sumit.sharma | last post by:
Hi, I have some experience in C prog language. I have small doubt abt using unions in C language. I have the foll. union union MyUnion { char name ;
2
3993
by: MLH | last post by:
Fields in MyTable: PostID PostDate RollQtyXfer RollDenomination RollCount37 RollCount23
4
1771
by: Stan | last post by:
I am running in ACCESS 2003 a database with a single table. It records service rendered to clients of a food pantry. As each client is served the date is entered into 1-6 fields SvcDate1, SvcDate2 etc. I would like to query certain data for monthly periods. The date of the month may appear in any one of the six fields. I now am running...
5
3832
by: wugon.net | last post by:
question: db2 LUW V8 UNION ALL with table function month() have bad query performance Env: db2 LUW V8 + FP14 Problem : We have history data from 2005/01/01 ~ 2007/05/xx in single big table, we try separate this big table into twelve tables and create a view
4
1460
by: bobdydd | last post by:
Hi All I have a query based on a single Table the has the following fields: Field 1: BoughtDate Field 2: SoldDate Sometimes the SoldDate is earlier than the BoughtDate What I am trying to do is put the LATER one of
0
7758
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8100
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8270
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
5651
isladogs
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5335
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3773
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3793
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2270
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1099
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.