I was about to do the same thing, good thing I chcked email before hitting send. Jason Carter CrossWired Solutions, LLC President and Lead Developer ...
515
Tim Mitchell
tdmitch
Jul 22, 2010 3:44 am
FYI ... From: SQL Lunch <webmaster@...> Date: Wed, Jul 21, 2010 at 2:45 PM Subject: SQL Lunch #27 - Let's Get Dimensional To: tdmitch@... Join...
516
Tim Mitchell
tdmitch
Jul 28, 2010 12:42 am
FYI ... From: Stuart Ainsworth <stuart.ainsworth@...> Date: Tue, Jul 27, 2010 at 12:07 PM Subject: [AtlantaMDF message] Chance to win all-expense-paid...
517
Andrew Brittain
brittain.andrew
Jul 28, 2010 2:13 am
Hello All I have a question to pose to the group regarding a T-SQL script... I'm racking my brain with this tonight and I'm under the gun. I am to update our...
518
Tim Mitchell
tdmitch
Jul 28, 2010 2:23 am
You could join the table back to itself, as such: UPDATE T1 SET QikLst = 'Y' FROM MyTable T1 INNER JOIN MyTable T2 ON T1.Bn = T2.Bn AND t2.QikLst = 'Y' Hope...
519
Jonathan Kehayias
jkehayia
Jul 28, 2010 2:29 am
I would just CASE the update like this: UPDATE MedRef SET Bn = CASE WHEN QikList = 'Y' THEN 'Y' ELSE Bn END Unless I am missing something. Jonathan Kehayias,...
520
Andrew Brittain
brittain.andrew
Jul 28, 2010 2:40 am
I just tried the CASE it changed the Bn to a Y I'll work on the join right now to see if that does it. The big issue is changing the remaining Bn name's Y for...
521
Andrew Brittain
brittain.andrew
Jul 28, 2010 3:15 am
Thanks again to both of you !! I've learned a few things while doing this... The JOIN worked... Your help is very much appreciated, I hope to return the...
522
Jonathan Kehayias
jkehayia
Jul 28, 2010 3:42 am
Ah, if you want to change them all Tim's solution should work, only it should have been: UPDATE T1 SET Bn = 'Y' FROM MedRef T1 INNER JOIN MedRef T2 ON T1.Bn =...
523
Jonathan Kehayias
jkehayia
Aug 3, 2010 4:26 am
Hey everyone, I have two Jr to Mid Level SQL DBA positions open at Tampa General Hospital that I am hiring for. If you are interested in applying please let...
524
Jose Chinchilla
joseraulchin...
Aug 7, 2010 12:56 am
Hello, I have an immediate opening for a 2-4 month project but could be extended to a permanent contracting work. Freelancers, consultants, staffers welcome. ...
525
Tim Mitchell
tdmitch
Aug 7, 2010 8:43 pm
FYI ... From: Sharon Dooley <sharond@...> Date: Sat, Aug 7, 2010 at 1:33 PM Subject: [ChapterLeaders] PASS DBA Virtual Chapter Live Meeting Event: ...
526
joseraulchinchilla
joseraulchin...
Aug 11, 2010 3:45 pm
Hello, I have an immediate opening for a 2-4 month project but could be extended to a permanent contracting work. Freelancers, consultants, staffers welcome. ...
527
Travis Page
dvmtthws9
Aug 21, 2010 10:53 pm
As promised I have posted a blog about importing data into SQL Server, please check it out: http://pagerwho.blogspot.com/ Thanks, Travis Page...
528
Garry McGibbon
swamprider5
Aug 25, 2010 2:16 am
I often use the sql server maintenance plans for backups, integrity checks, index rebuilds. It's convenient, but what would be really convenient is if I...
529
Jorge Segarra
sqlchicken
Aug 25, 2010 2:28 am
Check out this article by Brad McGehee on maintenance plans: http://www.simple-talk.com/sql/database-administration/database-maintenance- ...
530
Garry McGibbon
swamprider5
Aug 26, 2010 10:57 am
This article didn't address the question, other than a brief line stating it could not be done, which I rarely take at face value since dba's often find ways...
531
Good, Mike
mikegood10
Aug 26, 2010 3:23 pm
I have some research to the contrary, but wanted to see what everyone else said. Will take me a little while to find it.... From: tampasql@yahoogroups.com...
532
Jose Chinchilla
joseraulchin...
Aug 29, 2010 4:30 am
Garry, I have succesfully renamed a SQL instance and made maintenance plans to work. Essentially you will have to modify the Connection properties under the...
533
Good, Mike
mikegood10
Aug 29, 2010 3:49 pm
Great answer! From: tampasql@yahoogroups.com [mailto:tampasql@yahoogroups.com] On Behalf Of Jose Chinchilla Sent: Sunday, August 29, 2010 12:31 AM To:...
534
Garry McGibbon
swamprider5
Sep 1, 2010 1:37 am
Thanks for this info Jose. You are dba of the year! when I moved the maint plan the jobs got created automagically. I found that by changing the...
535
joseraulchinchilla@...
joseraulchin...
Sep 1, 2010 3:00 am
Great! Does that mean I get a free beer after next meeting? Sent on the Sprint® Now Network from my BlackBerry® ... From: "Garry McGibbon"...
536
Garry McGibbon
swamprider5
Sep 1, 2010 11:13 am
yes ... From: joseraulchinchilla@... To: tampasql@yahoogroups.com Sent: Tuesday, August 31, 2010 11:00 PM Subject: Re: [tampasql] copying maint plans...
537
Jose Chinchilla
joseraulchin...
Sep 1, 2010 9:03 pm
Hello my fellow SQL User Group friends: As some of you may already be aware, I will be starting my new job as Senior Business Intelligence Consultant for...
538
Jorge Segarra
sqlchicken
Sep 7, 2010 11:56 am
Hey all, Just wanted to let you know about a new virtual chapter coming online this week. This VC focuses on SQL Azure, check it out! Sent from my iPhone Begin...
539
Jim Pennington
sunstarems
Sep 20, 2010 7:49 pm
All, I'm trying to run a simple query via a linked server but a couple of XML fields is causing me problems and I get back the error:* "Target string size is...
540
Jonathan Kehayias
jkehayia
Sep 20, 2010 8:32 pm
Change: Cast(data as varchar(8000)) as XML_Data, Cast(MANIFEST as varchar(8000))as XML_Manifest, to: Cast(data as varchar(max)) as XML_Data, Cast(MANIFEST as...
541
Jim Pennington
sunstarems
Sep 20, 2010 8:52 pm
That worked, thanks!! Jim ... -- Jim Pennington...
542
Pam Shaw
pshaw1129
Sep 21, 2010 5:22 pm
Hello, I have been struggling with UG support site - they finally laid out that they were not supporting email until further notice. So this is the only ...
543
Travis Page
dvmtthws9
Sep 21, 2010 6:10 pm
I am in ... From: Pam Shaw <pshaw1129@...> Sent: Tuesday, September 21, 2010 12:49 PM To: tampasql@yahoogroups.com Subject: [tampasql] Tampa Bay SQL User...
