Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sp to count files inside x number of dir's inside one dir??

Status
Not open for further replies.
NickyJay

NickyJay

Programmer
Sep 1, 2003
217
GB
Hi all, hope this is the right forum, if not, please redirect me!

I want to be able to count the number of files inside 40 folders in one main dir. Is this possible using a sp?? how?

Manys thanks
Nicola :0)
 
Sort by date Sort by votes
What version you using? Try looking up xp_dirtree in BOL. You might be able to work it out from there.....

HTH,

M
 
Upvote 0 Downvote
xp_dirtree isn't in BOL. Information about it is available here
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Help with concatenation of BIG integers
Replies
0
Views
483
tekpr00
tekpr00
ItHurtsWhenIThink
  • Locked
  • Question
Using Distinct and count in same query???
Replies
4
Views
587
gk53
gk53
ciarra41
  • Locked
  • Question
Rollup to one record with same order number
Replies
2
Views
544
drlex
drlex
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
429
botatun
botatun
davikokar
  • Locked
  • Question
how to increase a value by one
Replies
1
Views
202
markros
markros

Part and Inventory Search

Sponsor

Back
Top