Viewing 15 posts - 361 through 375 (of 465 total)
There doesn't seem to be any clear consensus on all this, so I guess I'll have to build a bunch of test cases and see what comes of it. Still...
November 27, 2012 at 9:34 am
sjimmo (11/27/2012)
November 27, 2012 at 9:27 am
DiverKas (11/26/2012)
But wouldn't this always compare all variables, though? In the syntax with OR, the query engine can see that a variable is empty, thereby satisfying one side of the...
November 26, 2012 at 10:50 am
Luis Cazares (11/23/2012)
WHERE Oink.[System] like @System + '%'
ANDOink.Stratigrafie like @Stratigrafie + '%'
ANDOink.Ulozeni like @Ulozeni + '%'
AND Oink.DrEvid like @DrEvid + '%'
Or you...
November 24, 2012 at 6:36 am
Luis Cazares (11/23/2012)
The first is to change the empty string for a '%', that way you get rid of the ORs. You need to do...
November 23, 2012 at 1:57 pm
Gazareth (11/23/2012)
Best bet would be to test for each...
November 23, 2012 at 1:49 pm
Okay, it's running. I'm not quite sure exactly what finally did the trick - I played with modifying the access privileges, as one of the articles suggested, and I restarted...
October 30, 2012 at 10:32 am
Ignacio A. Salom Rangel (10/27/2012)
Did you try this link http://technet.microsoft.com/en-us/library/dd851678.aspx
Ok, unfortunately, that's not something I can work with. I am not a domain administrator. I have local admin privileges on...
October 29, 2012 at 5:54 am
Ignacio A. Salom Rangel (10/27/2012)
Did you try this link http://technet.microsoft.com/en-us/library/dd851678.aspx
No, that's something new, thank you. I'm not at work and have a slow connection here, but I'll try it as...
October 27, 2012 at 2:44 pm
ernesto.felix.city (10/26/2012)
I am a newbie and I am just confused for why it looks...
October 27, 2012 at 5:21 am
Developer, originally in Fortran, Cobol and RPG (I go back a few years), eventually migrated to Office/VBA, recently to Access/Sql Server. Accidental and unintentional DBA, along with still being a...
October 27, 2012 at 5:05 am
Hey, Lee, thanks for your input. It's always good to hear different perspectives, especially when those thought are accompanied by sound reasoning and underscored by experience. In my case, data...
October 20, 2012 at 11:45 am
Okay, I think I've got a reasonable plan. I'll do a nightly full, and an hourly differential and 15-minute transaction log during the day. The last will be mostly for...
October 18, 2012 at 12:40 am
AmarettoSlim (10/17/2012)
After reading the posts on this thread I'm sensing you already kinda know the acceptable thresholds of data loss based on experience in the company.
I do. It's the paleontology...
October 17, 2012 at 2:10 pm
Jamie Scharbrough (10/17/2012)
I guess I'm approaching this with the view that this is a learning enviornment, and so you should do all the...
October 17, 2012 at 1:23 pm
Viewing 15 posts - 361 through 375 (of 465 total)