Viewing 15 posts - 316 through 330 (of 399 total)
OK - getting closer. Now - I need to keep the historical stuff in there, so the idea is to not hard code the version t000, t001, t002, c000, c001,...
February 28, 2011 at 12:27 pm
Yeah that is essentially what I am trying to do. It needs to know it's the "c" or "t" version of the database, and then from there - know...
February 28, 2011 at 12:06 pm
The data types in the 2 tables in question are using nvarchar(10) and (20). TheTextValue holds a revision number, identified with either a "c" or a "t" and then...
February 28, 2011 at 12:02 pm
It returns *c%*, which I guess is the reason why it is bypassing the logic all together, and including both updates to a given database. But is there a...
February 28, 2011 at 11:53 am
Same result...I still get both. It's not determining which db it is.
:ermm:
February 28, 2011 at 11:38 am
Hi Pam -
Yes - in a nutshell I have tried:
< 001
= 000
<= 000
I'll give NOT EQUAL TO a try. I'm starting to thinking that I would be...
February 28, 2011 at 11:34 am
I think I am almost there...The script is running fine, using a single variable/parameter with potentially 1 of 2 values, but the problem I am getting is that when this...
February 28, 2011 at 11:22 am
I like this, but Richard Ding's creation "sp_sos" is a little more thorough, and is a PROC instead of a group of Functions.
http://media.techtarget.com/searchSQLServer/downloads/URL_for_SQL_Script_download_Tip_on_Sp_SOS.doc
February 25, 2011 at 1:35 pm
Hello Lowell -
First - thank you for always helping me out with my questions in the Newbies forum. I came across this work of yours today, and forgive...
February 25, 2011 at 10:17 am
Lowell, thank you for the starting place. He has a few CREATES after a DROP, but it seems like one or more DROPS are missing. Then again -...
February 25, 2011 at 9:22 am
Should I consider using a SELECT CASE instead of the IF statement?
February 25, 2011 at 9:14 am
Will it have to be a table valued function or a multi-valued function? This is 2005 SP3.
February 25, 2011 at 8:54 am
The point you make here is a good one, and in fact - has now raised a much different issue for me. Is there any way for me to...
February 24, 2011 at 10:09 am
Let me clarify further - here is what I am thinking from your suggestion:
- min server memory / max server memory = 4gb
- Virtual Memory Partition for Windows...
February 22, 2011 at 11:16 am
Sorry Craig - that was kind of vague. I was actually trying to ask about the Virtual Memory that the 2003 Server would be using from my C:\DRIVE. ...
February 22, 2011 at 11:04 am
Viewing 15 posts - 316 through 330 (of 399 total)