|
I have three tables family,productfamily(cross reference between product table and family),familycontent(cross reference between family and content), productcontent(cross reference between product and content)
Family table itself is the master of its own. Some families may be sub families of other family. For every family we need to go to familycontent table and see if record exists. If it does not, it should check its subfamilies and also productfamily and see whether any of the child family has got contents in familycontent or any of the products under that contains record in productcontent table. Child families can be upto 'n' level. We need to loop through like this until we loop through the entire hierarchy or until we get a record in either of the familycontent or productcontent table. Is there an easy way to get in SQL Query or we need to use Cursor and recursive function/Stored procedure. Please advice
|
|
|
|
|
|
Hi,
I am adding a file to a filegroup on a remote machine, and i don't know the direcotry structure of that machine, how can i provide the path for FILENAME param, since FILENAME params requires complete valid path of a physical file in that system.
ALTER DATABASE TESTDB ADD FILE (NAME = N'TESTFILE', FILENAME = N'physicalfilepath.ndf') TO FILEGROUP TESTFILEGROUP
Warm Regards,
Mushq
|
|
|
|
|
If this is going in the same place as the other files in the group you can find out the existing path with SELECT * FROM sysfiles
|
|
|
|
|
Hi all, i have a few quetion to discover, bee so pleasant to explain me how i can do:
1)
I have combobox and data source for one
<br />
this.comboBox1.DataSource = this.authorsBindingSource;<br />
Now I need to add to combobox an row, what not exist in bindingSource (supoose I want do display in combobox an additional row "not defined")
How I can do this????
---------------------------------------------------------------
2)
How I can to mark a rows in dataTable, so that ones not will be stored in database then this dataTable updated.
I mean:
<br />
<br />
DataRow dr1 = myDataTable.NewRow();<br />
<br />
..<br />
<br />
<br />
myDataTable.Rows.Add(dr1);<br />
<br />
<br />
DataRow dr2 = myDataTable.NewRow();<br />
<br />
..<br />
<br />
<br />
myDataTable.Rows.Add(dr2);<br />
<br />
this.myDataTableAdapter.Update(myDataTable);<br />
How I can do this.
-----------------------------------------------------------------------------------
3) How I can explore what column (DataColumn type) have default value???
|
|
|
|
|
Morning guys (GMT guys that is)
I am having issues deciding on exactly how to perform a very large chunk of programming. I need to query the database im working with to build up a table of statistics from the various tables within the database. Each product must be selected and then 10 individual statistics, many involving averaging and percentaging, must be generated per product. Therefore there will be 10 queries x the number of products found run each time.
The thing im not really sure about is quite where to put the programming itself. Should it be in a seperately coded class as part of my ASP.net project or should it be completely coded in sql in a stored procedure.
I need a speed, ease of achievability and also a managability perspective on any proposed technique. Thanks
|
|
|
|
|
Hi Sam
I would use a stored procedure based on the following SQL:
SELECT ProductCode,
(SELECT ###Statistics sub-select### FROM MyTable1 A
WHERE A.ProductCode = Product.ProductCode) AS Statistic1,
(SELECT ###Statistics sub-select### FROM MyTable2 A
WHERE A.ProductCode = Product.ProductCode) AS Statistic2,
###etc
FROM Product
ORDER By ProductCode You need to replace the "###" bits with SQL that matches your statistical requirements.
Hope that helps.
Andy
|
|
|
|
|
hi everybody!
I am a beginner in PL/SQL.I am currently doing a project based on PL/SQL with java as front end.
Basically I am developing an editor for PL/SQL.
I want to know how could we retrieve the resulting statements of PL/SQL program that is executed in Oracle.
for eg:
how to retrieve the result of a query say,
'Query completed successfully' which is displayed in Oracle editor to the front end form.
Does anybody know how to proceed with this?
Kindly bear with me as am new to Code Project.
If anybody of you know the answer, can you be so kind and
respond me!
Regards,
Shalini
|
|
|
|
|
|
Hi everybody,
I wrote a script in Installshield that changes the MaxLocksPerFile value in
Registry for Jet 3.x and Jet 4.0
While installing the application through Installshield, the custom value for
MaxLocksPerFile is being overwritten to 9500 in Registry for Jet
4.0(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0) but not
for Jet 3.x(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x).
The value is being overwritten to 9500 before the control reaches at the
script code.
I am wondering from where this 9500 value is being retrieved and set in
Registry.
Is there some file where these default values are mentioned.
If so then why 9500 value is not being set for Jet 3.x and is being set only
for Jet 4.0.
i am using MS Office 2002. Drivers for ODBC MS Access is above 4.0
and Installshield Version is 5.5.
Please help me to resolve this Issue.
-Regards
Harpreet
|
|
|
|
|
Hi,
Actually the what I am trying to implement is the following three requirements:
1) If the registry value Jet MaxLockPerFile is set to 30000 or lower the kit installation should set the value to 30000.
2) If the registry value Jet MaxLockPerFile doesn't exist the kit installation should set the value to 30000.
3) If the registry value Jet MaxLockPerFile is higher than 30000 the kit installation should not change this value in the registry.
To implement the above 3 requirements, I wrote the following script in Installshield:
szRegPath = "SOFTWARE\\Microsoft\\Jet\\4.0\\Engines\\Jet 3.x";
if(RegDBKeyExist(szRegPath) = 1) then
if(RegDBGetKeyValueEx(szRegPath, "MaxLocksPerFile", nzDummy,
szTmp, nzDummy) = 0) then
if (StrToNum (nVar, szTmp) = 0) then
if(nVar < 30000) then
nVar = 30000;
if(NumToStr (szTmp1, nVar) = 0) then
RegDBSetKeyValueEx(szRegPath, "MaxLocksPerFile", REGDB_NUMBER,
szTmp1, -1);
endif;
endif;
endif;
else
RegDBSetKeyValueEx(szRegPath, "MaxLocksPerFile", REGDB_NUMBER,
"30000", -1);
endif;
endif;
szRegPath = "SOFTWARE\\Microsoft\\Jet\\4.0\\Engines\\Jet 4.0";
if(RegDBKeyExist(szRegPath) = 1) then
if(RegDBGetKeyValueEx(szRegPath, "MaxLocksPerFile", nzDummy,
szTmp, nzDummy) = 0) then
if (StrToNum (nVar, szTmp) = 0) then
if(nVar < 30000) then
nVar = 30000;
if(NumToStr (szTmp1, nVar) = 0) then
RegDBSetKeyValueEx(szRegPath, "MaxLocksPerFile", REGDB_NUMBER,
szTmp1, -1);
endif;
endif;
endif;
else
RegDBSetKeyValueEx(szRegPath, "MaxLocksPerFile", REGDB_NUMBER,
"30000", -1);
endif;
endif;
Now for Jet 3.x it is working fine but when i check for fulfilment of the 3rd requirement in Regisrty(for Jet 4.0), the value changes to 30000, if previously it was greater than 30000.
This is because, the RegDBGetKeyValueEx function in script for(above) for Jet 4.0 retrieves the value 9500 instead of the value that we set greater than 30000( say 35000).
This is exactly what is happening. I will be highly obliged if anybody can help me to resolve this issue.
|
|
|
|
|
Hi all,
I am developing an employee search appl.I am using a textbox for name where the user can just enter the initials and entire name is searched.I am using stored procedures and passing the entered value as a parameter to stored proc.The problem is i haved framed the query as
select * from employee where fname like '@fname%';
this is not working and returns 0 rows
help!!!
|
|
|
|
|
in your case it is searching for the string starting with "@fname" as no data found starting with this string returns zero rows.
to my understanding @fname, in the query is variable.
if so, the same to be used as ...
select * from employee where fname like '%' + @fname + '%'
|
|
|
|
|
|
Hi,
Is it possible to use the parameter as an alias name for a column or any method I could use?
e.g.
@Conference - accepts either West or East, this is so that I could make use of the SP for Listing teams under East Conference and West Conference.
Create procedure [dbo].[sp_SelectConference]
(
@Conference varchar(20) = null
)
as
begin
select
TeamCity + ' ' + TeamNickName as @Conference + 'Confrence',
NumWins as 'Wins',
NumLoses as 'Loses'
from
teams
where
Conference = @Conference
end
Please advice
Dom;)
|
|
|
|
|
To my knowledge it is not possible.
however i'ld like to know the advantage in using alias of this
|
|
|
|
|
Hi Krish,
The query result will be binded to two data grid, west conference and east conference, and usually aliases appears as header text on the grid.
Dom
|
|
|
|
|
Hi
This is a good question. You need to assign your select statment in a temporary variable. And use that variable to execute your query 'exec (@sql)'. Please note here the bracket for executing statements. Hope this helps. 
For example:
use pubs
go
declare @sql varchar(2000)
declare @AliasName varchar(10)
set @AliasName = 'Eest'
select @sql = 'select fname as ' + @AliasName + ' from employee'
print @sql
exec (@sql)
-Harini
|
|
|
|
|
iwant to store a decimale value like (10.05) in a decimal column in a database SQL 2000 but it converts this value to zero.
what data type should i choose to store these values
Thanks
Dad
|
|
|
|
|
Need to specify both Precision & Scale for Decimal datatype.
for example ...
create table TblA(c1 decimal(5, 2), c2 varchar(10))
insert into TblA values(10.05, 'abc')
|
|
|
|
|
Thanks For help
but I want to know what does (Precision & Scale)means and how can i use them to meet my requirements.
Dad
|
|
|
|
|
for example to have a number with 3 digits on int portion and 2 of decimal
i.e. precision - 5 and scale - 2
means total digits are 5 (precision) out of that 2 are decimal places (scale)
|
|
|
|
|
Great Thanks
But what is the diffrance between decimal and float data type
and how can I store a value like this(123/34)in my database.
Dad
|
|
|
|
|
Numeric data types with
fixed precision and scale are
decimal[(p[, s])]
numeric[(p[, s])]
floating point data
float(n)
for a detailed explanation regarding decimal, numeric, float & real you can refer to online help on "Data Types"
commin for storing the value (123/34) is that you want to store result of this expression, then you can use either decimal/numeric data type with specific number of decimal places or float data type.
|
|
|
|
|
I need to know the steps to connect to the Access database from my C#.Net code written using VS 2005.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
