Viewing 15 posts - 2,401 through 2,415 (of 7,636 total)
De Morgan's laws:
1)
IF (NOT A=B) OR (NOT C=D)
is the same as
IF NOT ( A=B AND C=D)
2)
IF (NOT A=B) AND (NOT C=D)
is the same...
May 14, 2009 at 1:42 pm
Cwalton (5/14/2009)
I cant seem to ppost the XML correctly, I've added an attachment to show this.
You need to use the code tags: ..
May 14, 2009 at 1:22 pm
The right time to switch to stored procedures is as soon as you determine that it is going to be an actual application with actual users (as opposed to a...
May 14, 2009 at 1:18 pm
klnsuddu (5/10/2009)
Could you please anybody maintaining share point databases in sql server 2005, help me in creating multiple files for Content database, which is already in production with 70gb size....
May 14, 2009 at 11:51 am
Jeff Moden (5/14/2009)
Steve Jones - Editor (5/13/2009)
Ahhh, Klingons asking questions. About databases? Could be interesting....Heh... still not as bad as some of the questions folks ask on the forums. 😀
Steve...
May 14, 2009 at 11:13 am
That said, assuming that you cannot convert these to a more relational design, then your best approach is probably to parse the CSV field into a table variable or temporary...
May 14, 2009 at 11:04 am
bpowers (5/14/2009)
Lets say...
May 14, 2009 at 9:31 am
Alvin Ramard (5/14/2009)
Please try this and tell me what you get.
declare @CustomerRef as varchar(50)
set @CustomerRef = '00000012345678900'
select REPLACE(LTRIM(REPLACE(@CustomerRef,'0',' ')), ' ','0')
That won't work, Alvin. Rich is in the...
May 14, 2009 at 9:20 am
jparra (5/14/2009)
Developers develop and their task is to meet functional requirements. This means that they can prove through each iteration of their development that functions / procedures / methods...
May 14, 2009 at 7:42 am
Actually, folks, I believe that Rich already said that he tried using a single space and it didn't work.
If I am reading the screen shot correctly, I think...
May 14, 2009 at 7:27 am
jparra (5/14/2009)
Barkingdog (5/13/2009)
Good point:Of course while it may not match production data RedGat'es data generator (and others) is a good start in my opinion.
Barkingdog
But that's the whole point, isn't it?...
May 14, 2009 at 7:17 am
ondrej.bouda (5/14/2009)
Malcolm Daughtree (5/13/2009)
May 14, 2009 at 7:13 am
If you want to capture this out-of-request, thought, Trace/Profile is about the only accurate option.
May 13, 2009 at 11:38 pm
Viewing 15 posts - 2,401 through 2,415 (of 7,636 total)