dammit, I just realized that I missed the fact that the insert is attempting to execute in a different database even though the procedure is being run from the correct...

select isnull(cast(streetnumber as varchar(5)),'')

Based on where I work, I wouldn't expect anything. Not too sure what kind of constraint you could put onto the Scores table to enforce that the sum of...

two questions:

1. should we compensate for incomplete games, or assume the games are always going to consist of 10 frames?

2. do you want error checking/handling for invalid scores...

set @sourceFile = '\\networkname\filename.txt'

set @archiveFile = '\\networkname\filename.zip'

set @rar = '"C:\Program Files\WinRAR\rar.exe" a -df ' + @archiveFile + ' ' + @sourceFile

set @sqlstate =

'EXEC master.dbo.xp_cmdshell ''' + @rar + ''''

exec...

quote:

---

quote:

---

It said that the first 8 lines are used for determining whether the...