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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Joins
I dont think there will be a performance hit, its a pretty common thing to do, best way to find out is test it by copying the table over to the other database- SQLhell
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
-
stored proc for file counts (SQL 2000)?
Ah ok, Why not make a DTS package or SSIS for it, then use an Active X script like follows: Dim oFSO Dim folderName Dim count Dim file SET oFSO = CreateObject("Scripting.FileSystemObject") folderName = "d:\Files" SET fol = oFSO.GetFolder(foldername) SET files = fol.files count =...- SQLhell
- Post #4
- Forum: Microsoft SQL Server: Programming
-
stored proc for file counts (SQL 2000)?
Hi there, use xp_cmdshell 'dir c:' Any dos command can be executed through xp_cmdshell- SQLhell
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Crystal reports parameters
Hi there I need some help with a crystal report, I am using version 11. I have create a sql command with some temporary tables and some parameters, but I dont undertstand what happens if the user doesn't want to enter a value for the parameter, the only option is to leave it blank but ofc that...- SQLhell
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 2 Data Access
