Viewing 15 posts - 1,366 through 1,380 (of 3,507 total)
Exercised my Google-fu... Relational division, anybody?
https://stackoverflow.com/questions/15977126/select-rows-that-match-all-items-in-a-list
February 7, 2018 at 6:46 pm
I'm working on it... In T-SQL, it would be like this:
(Yes, I'm aware that this table design of Candidate is silly!!!)
.CREATE TABLE Candidate(
CandidateID INT...
February 7, 2018 at 5:55 pm
One thing to do is go find the local SQL Server User Group and go to the meetings. Open positions are often announced at the beginning of each meeting. If...
February 7, 2018 at 11:47 am
Sue,
Okay, I'll try it and post back when/if I get it working with what I tried. Seems odd that MS can't keep this stuff straight.
Almost glad I'm not...
February 6, 2018 at 3:28 pm
Lynn Pettis wrote a quick article on a bunch of useful date functions. It's here:
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/
February 6, 2018 at 11:38 am
I think I will. I could do the install once more (Imagine whiny kid voice "Again????!!!"), but once it's scripted, e-mail script to myself (or similar). Then I can just...
February 5, 2018 at 10:45 am
Sue,
Last question, since IT'S WORKING!!!
I know it's possible to script an install of SQL Server with a config file, but can I basically do it backwards (clone an...
February 5, 2018 at 9:30 am
The script wasn't for you, it was for the people trying to help you. Since you're new, I think you should read Jeff Moden's article on how to...
February 4, 2018 at 10:19 pm
So what's the answer supposed to be? What should the query return?
Here's how to post sample data...CREATE TABLE RouterData (
RouterName char(2),
A char(4),
B...
February 4, 2018 at 7:37 pm
The MSSQLSERVER (NT Service) has full permissions to the file(s). I never moved the files between uninstalling SQL Server and reinstalling it. Still no joy.
February 4, 2018 at 7:21 pm
Thanks for the help, Sue. I *think* I have it finally.
Either the SSRS documentation is awful or I seriously don't know how to read. I'm almost tempted to write...
February 4, 2018 at 4:23 pm
Except there's so much spam, you can't even taste the bacon!
February 3, 2018 at 8:17 am
So that's what goes in the Target Server URL property?
(Or wherever I specify where I want the reports published to?) That's the stuff that works great in Report Builder,...
February 2, 2018 at 7:15 pm
If I attempt to go to ReportServer (http://desktop-6p4std8/ReportServer), instead of getting a web site, I get
and then a list...
February 2, 2018 at 5:53 pm
Viewing 15 posts - 1,366 through 1,380 (of 3,507 total)