Viewing 15 posts - 8,401 through 8,415 (of 9,399 total)
Thanks for the question. It made me intentionally consider the %, leading space and trailing space. It looked to simple to actually be simple and I was looking...
February 13, 2014 at 5:17 am
BWFC (2/13/2014)
TomThomson (2/12/2014)
SQLRNNR (2/12/2014)
parsnipbutter (familiam non alunt verba)
Dairy
Cream
February 13, 2014 at 5:13 am
sing4you (2/12/2014)
crookj (2/12/2014)
L' Eomot Inversé (2/12/2014)
whereisSQL? (2/12/2014)
SQLRNNR (2/12/2014)
Ed Wagner (2/12/2014)
Revenant (2/12/2014)
JAZZ Master (2/12/2014)
crookj (2/12/2014)
Daniel Bowlin (2/12/2014)
SQLRNNR (2/12/2014)
Ed Wagner (2/12/2014)
BWFC (2/12/2014)
whereisSQL? (2/11/2014)
SQLRNNR (2/11/2014)
Lynn Pettis (2/11/2014)
Seventh Heaven! (All this delicious food!!)Cloud 9
ecstacy
Agony
Pain
Gain
overtake
Surpass
Overpass
Bypass
Heart
surgery
stitches
embroidery
cross-stitch
counted
Tally...
February 12, 2014 at 12:31 pm
Revenant (2/12/2014)
JAZZ Master (2/12/2014)
crookj (2/12/2014)
Daniel Bowlin (2/12/2014)
SQLRNNR (2/12/2014)
Ed Wagner (2/12/2014)
BWFC (2/12/2014)
whereisSQL? (2/11/2014)
SQLRNNR (2/11/2014)
Lynn Pettis (2/11/2014)
Seventh Heaven! (All this delicious food!!)Cloud 9
ecstacy
Agony
Pain
Gain
overtake
Surpass
Overpass
Bypass
Heart
February 12, 2014 at 9:29 am
Daniel Bowlin (2/12/2014)
SQLRNNR (2/12/2014)
Ed Wagner (2/12/2014)
BWFC (2/12/2014)
whereisSQL? (2/11/2014)
SQLRNNR (2/11/2014)
Lynn Pettis (2/11/2014)
Seventh Heaven! (All this delicious food!!)Cloud 9
ecstacy
Agony
Pain
Gain
overtake
Overcome
February 12, 2014 at 8:14 am
It was a simple question, but nonetheless a good one. How many times have we all been tripped up somewhere and spent hours on it, only to find that...
February 12, 2014 at 5:03 am
BWFC (2/12/2014)
whereisSQL? (2/11/2014)
SQLRNNR (2/11/2014)
Lynn Pettis (2/11/2014)
Seventh Heaven! (All this delicious food!!)Cloud 9
ecstacy
Agony
Pain
February 12, 2014 at 4:55 am
If you're going to execute them from SSMS, there is a piece of functionality that's really cool. In your Registered Servers, right-click the name of one of your groups,...
February 11, 2014 at 11:15 am
ChrisM@home (2/11/2014)
Brilliant! Thanks for posting this, Lowell. I can see it becoming famous 😉
Agreed. That is truly beautiful. 😀
February 11, 2014 at 11:12 am
Luis Cazares (2/11/2014)
Ed Wagner (2/11/2014)
The information_schema.columns table is an old system table, but it still supported. The replacement is sys.columns.
Why do say this? the old system table is syscolumns.
INFORMATION_SCHEMA...
February 11, 2014 at 11:09 am
You are accepting string parameters and then building a SQL command and executing it. That is the problem.
As an example, what if I were to look at your first...
February 11, 2014 at 11:01 am
To directly answer your question, it looks like you're referring to the column "pivot" which should be able to be renamed safely. The best approach is to always test...
February 11, 2014 at 10:38 am
Grant Fritchey (2/11/2014)
Sean Lange (2/11/2014)
jcrawf02 (2/11/2014)
wolfkillj (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
Word is that there are photos of a...
February 11, 2014 at 10:16 am
Kurt W. Zimmerman (2/11/2014)
jcrawf02 (2/11/2014)
Ed Wagner (2/11/2014)
BWFC (2/11/2014)
SQLRNNR (2/11/2014)
Ed Wagner (2/11/2014)
BWFC (2/11/2014)
Ed Wagner (2/11/2014)
SQLRNNR (2/10/2014)
Ed Wagner (2/10/2014)
SQLRNNR (2/10/2014)
Stuart Davies (2/10/2014)
Ed Wagner (2/10/2014)
crookj (2/10/2014)
Stuart Davies (2/10/2014)
BWFC (2/10/2014)
SQLRNNR (2/7/2014)
L' Eomot Inversé (2/7/2014)
SQLRNNR...
February 11, 2014 at 9:03 am
BWFC (2/11/2014)
SQLRNNR (2/11/2014)
Ed Wagner (2/11/2014)
BWFC (2/11/2014)
Ed Wagner (2/11/2014)
SQLRNNR (2/10/2014)
Ed Wagner (2/10/2014)
SQLRNNR (2/10/2014)
Stuart Davies (2/10/2014)
Ed Wagner (2/10/2014)
crookj (2/10/2014)
Stuart Davies (2/10/2014)
BWFC (2/10/2014)
SQLRNNR (2/7/2014)
L' Eomot Inversé (2/7/2014)
SQLRNNR (2/7/2014)
ConfidenceTrickster
TURN
Rotate
Twist
Ferris
Bueller (anyone...anyone)
Day off
Eye disease
Pink
Panther
Leopard
Tiger
Liger
Mule
Canyon
February 11, 2014 at 8:45 am
Viewing 15 posts - 8,401 through 8,415 (of 9,399 total)