|
Still didn't get this. Could you give an example?
|
|
|
|
|
mm.. lets see how to express this,
i have a parent table called (types)
in it i have many children and sub children tables.
i need to display them in a query where in the 1st column the table types should appear then in the second column the children of that table should appear and in the 3rd column the children of the children tables should appears.
ex: types(1st column)
--------sales_unp(2nd column)
--------sales
------------stock_flow(3rd column)
------------invoices_unp
------------invoices
--------unordered_items_hdr(2nd column)
------------unordered_items(3rd column)
...
|
|
|
|
|
So do you need a JOIN?
Like:
Select * from (types inner join sales on types.id = sales.typeid) inner join ...
|
|
|
|
|
to be honest i dont know what i need ... its logical to use joins if i want the children of tables to appear but to be honest its an alien query to me... i feel so weak in queries 
but ofcourse i cant join all the tables there r so many! there must be a way to cite them all and display them in such way or else my boss wouldnt have told me to do so...
|
|
|
|
|
|
the SELECT * from table...
would display the fields in that table..
this is not what i need. i need the table names only. not the fields in them.
|
|
|
|
|
|
THANK GOD WE ARE UNDERSTANDING EACH OTHER.. 
look the interbase (ibexpert) doesnt use sys.anything
there must be some sort of other kywords for such database...
this is my main issue. i have allready found sys.datatable_name...and stuff
but the sys is not understood by ibexpert.. 
i tried to google it ... i found an answer in experts exchange.com
but in order to view the answer i had to pay! and i dont have any credit cards on me...
to be honest no matter if u could help me or not i am so thankful for your support! so thankful for taking time one me like this.
|
|
|
|
|
Scroll down to the bottom of the page (experts exchange). After all the advertising there will be the solution (don't know why they want to pay for this...).
|
|
|
|
|
i cant belive the result was under my nose all the time and i didnt see it! 
thank you sebastian...
ill never forget your support!
if u got curious ...
the thing i wanted is (you type in google fetch parent child tables interbase) you will get the title article (fetch parent child... uppercased u enter it and you will find what i wanted exactly..)
thank you so much. hop this works.becos it says oracle ...
thank you again 
|
|
|
|
|
id person bar
1 ankur royal
2 ankur wishy
3 punit royal
4 punit wishy
5 ankit royal
result will be
Ankur
punit
i want to list person who use more than one bar.how can i do...i want sql query for ms access.
thank in advance...
!- F - R - I - E - N - D - S -!
|
|
|
|
|
SELECT person
FROM [tablename]
GROUP BY Person
HAVING COUNT(bar) > 1
|
|
|
|
|
what is wrong in following query.
datatype of @Name is text.
@Name is parameter passing in stored procedure
select * from students
where first_name in ( + @Name + )
|
|
|
|
|
Which error message do you get?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
Error:
Msg 102, Level 15, State 1, Procedure GetFinancialInfo, Line 48
Incorrect syntax near ')'.
|
|
|
|
|
I would take a look on the SQL statement directly before executing.
|
|
|
|
|
You cannot use an IN with a variable. Either use dynamic sql or, my preferred method, use a function to split the list into a table variable and join on that. A quick google will give you examples, but here is a starter
CREATE FUNCTION [dbo].[fn_DelimitedSplit]
(
@TextToSplit VARCHAR(8000), @Delimiter VARCHAR(255)
)
RETURNS @SplitKeyword TABLE (Keyword VARCHAR(8000),seq int identity)
AS
BEGIN
DECLARE @Word VARCHAR(255)
WHILE (CHARINDEX(@Delimiter, @TextToSplit, 1)>0)
BEGIN
SET @Word = SUBSTRING(@TextToSplit, 1 , CHARINDEX(@Delimiter, @TextToSplit, 1) - 1)
SET @TextToSplit = SUBSTRING(@TextToSplit, CHARINDEX(@Delimiter, @TextToSplit, 1) + 1, LEN(@TextToSplit))
INSERT INTO @SplitKeyword(Keyword) VALUES(@Word)
END
INSERT INTO @SplitKeyword(Keyword) VALUES(@TextToSplit)
return
END
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Using Visual Web Developer Express and SQL Server 2005 on an XP development machine.
Was using development server in VWDE to view pages, using following connection string:
|connectionStrings|
|add name="RHConnectionString" connectionString="server=MIKE;database=Rotary;Trusted_Connection=True;"/|
|remove name="LocalSqlServer"/|
|/connectionStrings|
Needed to test with SSL. Installed SSL certificate (using your makecert procedure, thanks). Moved web site to IIS and opened in VWDE. Development connection to database works, but pages get Login failed for user 'MIKE\IUSR_MIKE'.
SQL Server configured for Remote Connections and mixed Windows Authentication and SQL Server authentication.
Any help?
|
|
|
|
|
Go to your management Studio. Right click your Server and go to properties. in the Properties go to Security and look at the Options under Server Authentication. and tell us what is selected there.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Dont know if this may help but worth a try go to SAL Server Surface Area Configuration and then Surface are configuration for services and connections. Choose Remote connections, check Local and remote connections and choose TCP/IP only. Hope this helps
|
|
|
|
|
Thanks for your attempts to help. I "solved" the problem by creating a new user ID and giving it the access rights I was trying to give my primary Windows login ID.
|
|
|
|
|
what is wrong with this code
create XML SCHEMA COLLECTION JointCollection
AS
N'<xs:schema
attributeformdefault="unqualified"
elementformdefault="qualified"
xmlns="http: www.w3.org="" 2001="" xmlschema"="">
<xs:element name=":Members"">
<xs:complextype>
<xs:sequence>
<xs:element maxoccurs="unbounded" name="Member">
<xs:complextype>
<xs:sequence>
<xs:element name="LastName" type="xs:string">
<xs:element name="FirstName" type="xs:string">
<xs:element name="MiddleName" type="xs:string">
<xs:element name="GenderId" type="xs:int">
<xs:element name="Telephone" type="xs:string">
<xs:element name="Email" type="xs:string">
<xs:element name="ContactAddress" type="xs:string">
<xs:element name="ContactCity" type="xs:string">
<xs:element name="ContactStateId" type="xs:int">
'
when i execute this in sql server 2005 i got error
Msg 9459, Level 16, State 1, Line 1
XML parsing: line 4, character 41, undeclared prefix
|
|
|
|
|
Judging by the example on MSDN here[^], you have missed out a whole chunk:
<xsd:schema targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions"
xmlns ="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions"
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
how can i create xml schema for the for a typed xml datatype using management studio(sql server 2005)
|
|
|
|
|
If you load the data into a datatable, you can invoke a method to create your scehema.
Dim dt As DataTable
dt.WriteXmlSchema()
Maybe that will help.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
