Viewing 15 posts - 76 through 90 (of 312 total)
I tried to have SQLCMD respect a variable in a .SQL file but it does not seem to allow that. So I decided to go another way. I...
April 18, 2012 at 9:04 am
The reason I want the variable with the path is because there are about 20 backups and restores. These backups and restores reside in a .sql file. I...
April 17, 2012 at 2:11 pm
Sorry about the confusion. I have changed the original to show varchar. These tables are examples and not the real thing. I am trying to represent the...
March 5, 2012 at 4:17 pm
Sorry for the late reply but that did not help the processing out at all. I saw no difference in processing
We use this method all over. I am...
September 22, 2011 at 11:59 am
I think we are in agreement. That is some slick code. Tomorrow I will put together the actual loop on real data. This just made my life...
July 21, 2011 at 9:09 pm
Yeah K Smith changed my goal. Now I want it allllllllll. 🙂 Going into this I really thought there was a function that would just do this....
July 21, 2011 at 4:54 pm
M.Maggoo - That is an unbelievable query but the results are the same as my loop. Where if I am looking for BCD 414 I get
search_keyidthenamevalue
BCD 4141bcd 41410
BCD...
July 21, 2011 at 4:43 pm
K Smith Thanks that is pretty slick and gets the results to where abcd 414 drops in rank. So you go through every Ascii symbol between 33 and 126...
July 21, 2011 at 4:35 pm
Thanks for this post. There is a ton of bad information surrounding this problem. Changing the service from manual to automatic and starting it up worked well and...
July 21, 2011 at 3:08 pm
You are correct and the problem I am working with is around 3K in records. So I am hoping for more of a robust solution besides the one I...
July 21, 2011 at 11:34 am
I understand that I needed some detail. In the real process I will have an outer control loop that will feed in values like "BCD 414". I want...
July 21, 2011 at 9:51 am
Well that was a good read between you guys. Thanks for the effort. So I am looking at the performance of a few things that came to mind....so...
May 12, 2011 at 1:11 pm
It is .Net but the problem I have is we are forced to code to 2005 and greater. That means my TVP is a CSV. They are already...
May 12, 2011 at 9:35 am
I understand what you are saying because I feel that way often...Problem is I am the chosen Gatekeeper or Architect. They will listen if I steer them in the...
May 12, 2011 at 8:18 am
Thanks hopefully this helps me get to a better point on how to manage this mess
April 26, 2011 at 4:00 pm
Viewing 15 posts - 76 through 90 (of 312 total)