Viewing 15 posts - 6,166 through 6,180 (of 9,399 total)
Sorry, without having DDL, I just created a CTE to simulate the table. If you substitute it like Lynn did, you'll be all set.
April 28, 2015 at 10:44 am
Just because I'm someone who doesn't like cursors, I feel compelled to offer an alternative.
DECLARE @strSQL Varchar(MAX) = '';
WITH FinalDBleverluser(dbname, username) AS (
SELECT 'db1', 'user1' UNION ALL
...
April 28, 2015 at 10:17 am
Revenant (4/28/2015)
SQLRNNR (4/28/2015)
TomThomson (4/27/2015)
SQLRNNR (4/27/2015)
marlinspike
hall
fame
Fortune
April 28, 2015 at 10:08 am
Eirikur Eiriksson (4/28/2015)
crookj (4/28/2015)
Ed Wagner (4/28/2015)
djj (4/28/2015)
Eirikur Eiriksson (4/27/2015)
TomThomson (4/27/2015)
SQLRNNR (4/27/2015)
marlinspike
Top
Apex
Predator
Alien
Immigrant
Legal
April 28, 2015 at 7:33 am
djj (4/28/2015)
Eirikur Eiriksson (4/27/2015)
TomThomson (4/27/2015)
SQLRNNR (4/27/2015)
marlinspike
Top
Apex
Predator
April 28, 2015 at 5:13 am
With 87% getting it right at this point, that's encouraging. I guess I just took knowing that for granted and never gave it a second thought. It's always...
April 28, 2015 at 5:09 am
SQLRNNR (4/27/2015)
Lynn Pettis (4/27/2015)
Ed Wagner (4/27/2015)
Grant Fritchey (4/27/2015)
Hey Steve! Where did you get pictures of my cousin?I never thought of you as having a strong feline side. 😀
How many people...
April 27, 2015 at 2:03 pm
Eirikur Eiriksson (4/27/2015)
eccentricDBA (4/27/2015)
SQLRNNR (4/27/2015)
marlinBrando (his fishy cousin)
The horror
The Pain
April 27, 2015 at 1:26 pm
djj (4/27/2015)
Eirikur Eiriksson (4/27/2015)
Ed Wagner (4/27/2015)
Revenant (4/27/2015)
TomThomson (4/27/2015)
Eirikur Eiriksson (4/27/2015)
Ed Wagner (4/27/2015)
djj (4/27/2015)
CopperCanyon
Crossing
Out
Outhouse
Doghouse
Hut
Pizza
Wings
April 27, 2015 at 11:21 am
Grant Fritchey (4/27/2015)
Hey Steve! Where did you get pictures of my cousin?
I never thought of you as having a strong feline side. 😀
April 27, 2015 at 11:20 am
neeraj-344433 (4/27/2015)
It is a nightly ETL job. Once the data is loaded in the staging table, the process picks it up and loads into other system.
That's the 16-hour run you...
April 27, 2015 at 10:56 am
You have a table with 85 columns and 3M rows. Do you need to query all of them every time?
April 27, 2015 at 10:48 am
Brandie Tarvin (4/27/2015)
Lynn Pettis (4/27/2015)
Ed Wagner (4/27/2015)
Lynn Pettis (4/27/2015)
April 27, 2015 at 10:40 am
Lynn Pettis (4/27/2015)
April 27, 2015 at 10:33 am
Revenant (4/27/2015)
TomThomson (4/27/2015)
Eirikur Eiriksson (4/27/2015)
Ed Wagner (4/27/2015)
djj (4/27/2015)
CopperCanyon
Crossing
Out
Outhouse
Doghouse
April 27, 2015 at 10:31 am
Viewing 15 posts - 6,166 through 6,180 (of 9,399 total)