Showing posts with label catch. Show all posts
Showing posts with label catch. Show all posts

Wednesday, March 28, 2012

Need help / suggestion

Hey guys

I have to implement a dynamic Parent - > Child Scenario ... but the catch is
as Follows :

I need to create this Table Design so that I can have multiple Parent ->
child - > parent Relationships

(ie Db driven "Window Explorer - feel". 1 Folder that holds another Folder
that holds another Folder etc to Infinite )

So if the Above makes any sense ... Suggestions would be Welcome

Thanx1) Get a copy of TREES & HIERARCHIES IN SQL for several different
methods

2) Google for "nested sets", "path enumeration" and "adjacency list"
models in SQL|||Thanx !!!

"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1109335451.349754.115330@.l41g2000cwc.googlegr oups.com...
> 1) Get a copy of TREES & HIERARCHIES IN SQL for several different
> methods
> 2) Google for "nested sets", "path enumeration" and "adjacency list"
> models in SQL|||Nice 1 celko !!! :P
http://www.intelligententerprise.co...equestid=315563

"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1109335451.349754.115330@.l41g2000cwc.googlegr oups.com...
> 1) Get a copy of TREES & HIERARCHIES IN SQL for several different
> methods
> 2) Google for "nested sets", "path enumeration" and "adjacency list"
> models in SQL

Wednesday, March 7, 2012

need a remote bcp or similar utility

We are looking for a way to load a database with bcp during an install. The catch is that the input file and the install (which would kick off the bcp load) can be on a different machine than the database (and the bcp.exe). Any ideas?
Kevin,
for bcp.exe it doesn't matter whehter the data files or database servers are
remote or local. So, you should be able to load your data with no problem.
Tengiz Khartishvili
SQL Server Storage Engine
This posting is provided "as is" with no warranties and confers no rights.
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:9D3090CE-91A8-42B1-8C40-928FC0DC33EC@.microsoft.com...
> We are looking for a way to load a database with bcp during an install.
The catch is that the input file and the install (which would kick off the
bcp load) can be on a different machine than the database (and the bcp.exe).
Any ideas?