Viewing 15 posts - 5,116 through 5,130 (of 26,490 total)
Letron Brantley (5/28/2015)
Thanks Lynn,"Yes" to all three of your questions.
Letron
Letron Brantley (5/28/2015)
TableA = 600million records
TableB = 0...
May 28, 2015 at 1:41 pm
Letron Brantley (5/28/2015)
TableA = 600million records
TableB = 0 records
To "move" data from TableA to TableB
Rename TableA --> TableA_HOLD
Rename...
May 28, 2015 at 1:28 pm
I just want to throw this out there regarding the data and your application, and realize that this is my own opinion, and the following quote from an earlier post:
eichnerm...
May 28, 2015 at 9:34 am
meilenb (5/27/2015) ...
Oh and we don't need to sit here and sling insults. You've got 2 under your belt.
Only problem here, I haven't slung ANY insults. You'd know...
May 28, 2015 at 9:02 am
jurgen.lottermoser (5/27/2015)
I have done enough research on climate change to know that unlike the politicians that claim the climate change is settled science, it isn't.
don't mean to rain on your...
May 27, 2015 at 4:13 pm
meilenb (5/27/2015)
Alan.B (5/27/2015)
meilenb (5/27/2015)
Alan.B (5/27/2015)
Lynn Pettis (5/27/2015)
meilenb (5/27/2015)
Alan.B (5/27/2015)
meilenb (5/24/2015)
...Everyone knows that CO2, CH4 and N2O ...
How is the science clear on climate change when the scientists can't agree?...
May 27, 2015 at 3:51 pm
Meatloaf (5/27/2015)
In hopes to simplify, here is my Pseudo code:
IF (vchDept='IT') THEN iDeptID=1
ELSE
IF (vchEmail like '%@abc.com' AND vchDept<>1) THEN iDeptID=2
ELSE
IF (vchEmail like '%@123.com' AND vchDept<>1) THEN...
May 27, 2015 at 3:07 pm
ScottPletcher (5/27/2015)
Do you really need the "PersonID<>0", or could you remove that? I believe...
May 27, 2015 at 1:53 pm
SQLRNNR (5/27/2015)
GilaMonster (5/27/2015)
Looks like I hit a few nerves with Sunday's editorial....Two words...
Ugh
Troll
Yes, I know, don't feed the troll and all that nonsense. Just can't seem to help myself.
Hi,...
May 27, 2015 at 12:27 pm
meilenb (5/27/2015)
Alan.B (5/27/2015)
Lynn Pettis (5/27/2015)
meilenb (5/27/2015)
Alan.B (5/27/2015)
meilenb (5/24/2015)
...Everyone knows that CO2, CH4 and N2O ...
How is the science clear on climate change when the scientists can't agree? Plus,...
May 27, 2015 at 12:24 pm
meilenb (5/27/2015)
Alan.B (5/27/2015)
meilenb (5/24/2015)
...Everyone knows that CO2, CH4 and N2O ...
1. It's hard to prove that Everyone knows anything. Statements like "everyone knows" and "we all agree" are antithetical...
May 27, 2015 at 11:53 am
meilenb (5/27/2015)
It's not contradictory. It is reality
This appears random. To what statement were you making this comment?
May 27, 2015 at 11:20 am
Meatloaf (5/27/2015)
I am looking to create a simple IF Else statement in a SPROC but my syantax seems to be wrong. Can someone advise what I am doing wrong?
IF (vchDept='IT')
BEGIN...
May 27, 2015 at 11:15 am
Just another option:
declare @t table
(
id char(2),
type int
)
insert @t (id, type) values
('c1', 0)
,('c2', 5)
,('c3', 0)
,('c4', 0)
,('c4', 7)
,('c5', 9)
...
May 27, 2015 at 10:56 am
What is the recover model being used by the database?
May 27, 2015 at 10:39 am
Viewing 15 posts - 5,116 through 5,130 (of 26,490 total)