Viewing 15 posts - 9,181 through 9,195 (of 14,953 total)
Here's what I have on hierarchies in SQL[/url].
From what you're describing, I'd go for a table of the modules, and another table of the awards, and a many-to-many of the...
June 23, 2009 at 2:33 pm
RBarryYoung (6/23/2009)
Now, if you want to see some truly hideous code, try this. 🙂
My favorite line isn't even in the code. It's, "you can find below the solution...
June 23, 2009 at 11:41 am
I just took a pair of online DBA tests the other night. Both were focused on database development. Both had a lot of questions that I really wanted...
June 23, 2009 at 10:00 am
Eswin, I'm going to suggest hiring a contractor to sort that one out for you. It's going to take a few hours, at the very least, and getting it...
June 22, 2009 at 12:24 pm
I'm pretty sure Excel won't allow you to do that.
Why not export the XML to text files instead of Excel?
June 22, 2009 at 12:18 pm
Script the logins and roles, back up the databases and restore them on the new server, and you can either do the same with msdb (for DTS packages and jobs),...
June 22, 2009 at 12:16 pm
I keep SQL Server patched on the known servers and on my desktop (Dev Editition). But, as has been mentioned, it's entirely possible there are copies of Dev or...
June 22, 2009 at 7:36 am
Excellent. Good solution.
June 19, 2009 at 7:01 am
I'm more than capable of "rolling my own" when it comes to maintenance scripts, but I don't bother. SQL 2k5 maintenance plans work just fine for me, and I...
June 19, 2009 at 6:52 am
Change this:
insert into tblDirectory
SELECT
E_ID
,N_ID
,LAST_NAME_PRIMARY AS LAST_NAME
,FIRST_NAME_PRIMARY AS FIRST_NAME
,MIDDLE_NAME_PRIMARY AS MIDDLE_NAME
,NAME_PRIMARY as NAME
,convert(datetime, birthdate) as BIRTHDATE
,MAIL_ADDRESS1 AS ADDRESS1
,MAIL_ADDRESS2 AS ADDRESS2
,MAIL_CITY AS CITY
,MAIL_STATE AS STATE
,MAIL_POSTAL_ZIP AS POSTAL
,MAIL_COUNTRY_LDESC AS COUNTRY
,MAIL_PHONE_NBR AS PHONE
,EMAIL_PREFERRED...
June 18, 2009 at 3:07 pm
As to which will be in first place, it'll depend on how fast they run. If, for example, I were an MCA (I'm not), and Gail were an MVP...
June 18, 2009 at 8:28 am
Dugi (6/18/2009)
Just curious who is the Best, and who has the Most Value!
I'm going to have to go with MCA.
The Metro Center for the Arts is definitely better...
June 18, 2009 at 8:21 am
"Best minds" are great for open discussions, but not what I'd be looking for in a presentation. There, I'd be more interested in "knows more than I do, or...
June 18, 2009 at 8:11 am
Yeah. Don't remember where I got it from, but thought it was worth hanging on to. (The quote)
June 18, 2009 at 7:32 am
Viewing 15 posts - 9,181 through 9,195 (of 14,953 total)