Hi, dear
I have 3 ASP.Net systems that reference a VB.Net dll.
I need 4 setups to install systems(3) and dll(1).
If I alter code only in VB.Net dll, Do I need to generate all 4 setups or only the VB.Net setup?
What about the systems(3) references to dll?
Thank's
Ofsouto
Brazil
I want to show all registers from a table(CODE, DESCRIPTION) and show an additional collum with the row number(INCREMENT).
Select * from table_1
RESULT:
CODE DESCTIPTION INCREMENT
-------- ------------------------- -----------
03354718 FIRST_DESCRIPTION 1
54654654...
Thank you, chekai. It works.
Could you answer me another question?
What's better? Subqueries or Derived Tables?
I know I could use subquery to get the result but I don't know about the performance.
Thank you again.
Obede
Brazil
I have two queries:
SELECT DISTINCT tot.po_tble_cod
FROM po_tabelatotal tot (NOLOCK),
po_tabelaitem itm (NOLOCK),
po_parametro par (NOLOCK)
WHERE tot.po_tblt_cod = itm.po_tblt_cod
AND itm.po_para_cod = par.po_para_cod
AND par.po_bloc_cod = 99
returns: 42, 43, 65, 114...
The problem was solved:
SELECT DISTINCT fun.function_desc, fun.function_code
FROM table_1 fun
INNER JOIN table_2 itm
ON fun.function_code = itm.function_code
INNER JOIN table_3 par
ON itm.parameter_code = par.parameter_code
WHERE par.class_code = 1
AND fun.function_code NOT IN (
SELECT...
I need to list all functions (codes and descriptions) with item functions that have only parameters with class code = 1.
It is wrong if the function has item functions with one parameter with class code = 1 and another parameter with class code = 2.
Thank you very much.
Obede
I have 3 tables
table_1
function_code
function_desc
table_2
function_code
itemfunction_code
itemfunction_desc
parameter_code
table_3
parameter_code
parameter_desc
class_code
I need to list all functions (code and description - table_1) where the item functions (table_2)
have only parameters...
Hi, dear
How can I get the inner text of "user" and "quantity" nodes?
<Monitore xmlns="Monitoramento por Lote">
<Lote>
<user>SIABE001 SC01</user>
<quantity>1</quantity>
<register>MR2000000000001I1IMR </register>
<register>MR2000000000002I1IMR </register>...
Hi, dear
I need to get the full text of a text datatype collumn of a sql-server table.
I tried the example of this link (http://www.kbalertz.com/Feedback_317034.aspx) and change getbytes to getchars and I didn't get the full
text. What's wrong? How can I get the full text?
Thank you very much...
Hi, dear
I need to get the value of a text datatype collumn in a SQL-Server table.
The text length is 2196 characters, but when I try to get it by datareader or dataset the text
length is 696.
What's wrong? How can I get the full text?
Thank you very much.
Obede
Brazil
I intend to write more than one query in only one XML file.
WriteXML permits write/save only one query.
After write/save XML file I need to read/convert to dataset.
Thank you.
Hi, dear
I need to save the result of some queries as XML files.
I know that I can use datasets.
I would like to know if it's possible to save these queries in only one XML file.
Is it possible to read and convert this XML file in datasets?
Thank you very much.
Obede
Brazil
I'm querying data from a table.
I have the table bellow
CREATE TABLE [dbo].[AC_CARTEIRA] (
[ac_suplier_code] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ac_date] [smalldatetime] NOT NULL ,
[ac_client_code] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ...
Hi, dear
A date (GetDate()) is a stored procedure inside parameter.
I need to list the last 13 month/year.
I need to generate a query where I can get the result bellow:
01/2005
12/2004
11/2004
...
02/2004
01/2004
Is it possible? How can I get it?
Thank you very much
Obede
Brazil
I had solved the problem.
I created an object as an arraylist and I set it = session("config").
Dim arrConfig As ArrayList = Session("config")
lblUsuario.Text = CType(arrConfig.Item(5), String).Trim
Thank you very much.
Dear sir
I'm getting this error while trying to access an ASP.NET system on a Server.
An user log on windows and can access the main page on ASP.NET system.
Another user lon on windows and can't access the main page on ASP.NET System.
Both are using the same machine.
I tried again on another...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.