Yes, exactly....Thank you also for taking the time to respond and help...Joe Wolfe
Sorry for the late reply, I've been traveling and super-busy but have been meaning to get back to this post. I'm sorry to say that I don't have much of a solution, it just looked like people in this thread were not understanding your problem. I have seen other equally weird behavior in BIDS (Business Intelligence Development Studio) that I was fixed by a re-install.
The problem you are having appears
to be related to BIDS (if that is what you are using). You said that you tried re-installing SQL Server - did you reinstall BIDS as part of that? Either way you may want to re-install BIDS (e.g. run the installer, do add/remove componants, remove BIDS... run the installer again and add BIDS. You may also check for updates. If you are using full blown Visual Studio instead of BIDS then re-installing SQL Server would not have fixed anything and you may want to re-install Visual Studio.
My world is mostly SSRS these days and, I'll be honest, I just use this stuff and have not installed/configured VS/BIDS in a few years so take what I said with a grain of salt. The best advice I can give is to re-post this problem under Reporting Services 2008 Development
with the Title, "Problem with BIDS". I think you'll get a better answer. Hope that helps.
P.S. If you are at SQL PASS (I could not go this year
) - go talk to the CAT
people. They'll figure it out in 30 seconds (they're real good)
-- Alan Burstein
Best practices for getting help on SQLServerCentral -- Jeff Moden
How to Post Performance Problems -- Gail Shaw
Nasty fast set-based string manipulation functions:
For splitting strings try DelimitedSplit8K or DelimitedSplit8K_LEAD (SQL Server 2012+)
To split strings based on patterns try PatternSplitCM
Need to clean or transform a string? try NGrams, PatExclude8K, PatReplace8K, DigitsOnlyEE, or Translate8K
I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code. -- Itzik Ben-Gan 2001