Organisation Question
Jun 23, 2005
I'm pretty new to all things database and SQL.
I'm currently using SQL Server Express Edition.
I want to know what the best way to organise my databases for my "web application".
I currently have all my tables in one database which makes things
easier to manage. However, if I want to make changes to certain tables
or add tables etc it means taking the whole web application offline.
Perhaps it would be easier to logically group the tables into separate
databases; i.e. all things travel related go into a travel database,
all affiliate tables go into an affiliate database and so on.
Is this best way to organise my tables?
View 1 Replies
Mar 8, 2006
Hi folks,
I have a Employee Master table named "Employee_Master". This has got the fields like as follows,
Employee_ID
Employee_Name
Reporting_To
Now I need a query that can help me to build up the organisation chart. I have a query that gives me some data......... Its like
select emp.employee_id,emp.employee_name,
mgr.employee_name as reporting_manager
from employee_master emp ,employee_master mgr
where emp.reporting_to=mgr.employee_id
But the problem with this query is, it gives only 1:1 mapping. And my requirement is to build a tree structure.........
So please help me oput in this regard........
Please lemme know if the problem is not understood to ya guys.......
Waiting for the earliest reply..........
Thanks,
Rahul Jha
View 1 Replies
View Related
Oct 1, 2007
Hi,
here is my problem
i've a table in my database like this
Col1 | Col 2
____|______
aaa | 111
aaa | 222
aaa | 333
bbb | 222
bbb | 333
to insert data into a flat text file or another table
i would like to make a dataset like that :
Col1| Col2| Col3 | Col4
____|____|_____|_____
aaa | 111 | 222 | 333
bbb | 222 | 333 | NULL
the table is quite big, so i can't make it line by line
i would like to have a maximum of 12 column ( if there is more data than 12, these data should be ignored )
thanks for answering
View 3 Replies
View Related
Sep 22, 2006
I would like to create a set of packages which could be used as a basic package for other people. This package /project/solution should be used in a way that another a person could manipulate it in BIDS nad save it as a stand-alone package.
I already created some child packages and one package which should act as a "template" for developing a new package. The devloper should integrate existing child packages very easily.
All developers will share the same network directoy where all the solutions/projects/packages will be stored (which is not a problem to realize it) But how can it be organized that you can have a basic package which can be used as a general "template"?
Does anybody have a good idea, how this could be organized?
Norbert
View 1 Replies
View Related
