I just wanted to report back that I found what I needed in faq183-5207, Option 4.
Thanks for the guidance SQLSister, and excellent write-up ESqared.
Ryan
Hi All,
I had a thread last year asking about how to do some more advanced filtering using the WHERE clause, as seen here: thread183-1366770.
The result was the code here:
Declare @Temp Table(UserName VarCHar(100), EyeColor VarChar(100), ShoeSize int)
Insert Into @Temp Values('devRyan'...
Hi All,
I was hoping you could help me with some questions I've got about SSIS/BID. I'm familiar with the workings of previous versions of DTS, but haven't yet dug into the newer implementation(SSIS/BID) in SS2005 so am having some difficulty determining how I need to go about getting done the...
Hi All,
Was hoping I could get some quick help. I'm trying to use the FSO to create a file, but can't seem to get it to work.
Could someone please tell me what I'm doing wrong?
I've got the Windows Scripting Library is referenced, so it recognizes my objects. Mainly though, I don't know what...
I can see the FileDialog in my Object browser, but I can't seem to use it, and the reference option in tools is greyed out, so I can explore adding new references.
Nevermind, I found this, which does the job for me.
Dim dlgSaveAs As FileDialog
Set dlgSaveAs = Application.FileDialog(msoFileDialogSaveAs)
dlgSaveAs.Show
Just curious. In looking at your usage of the CharCount function, why wouldn't you simply use inStr? Since you're not actually looking for a certain number of instances > 0.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.