Viewing 15 posts - 3,361 through 3,375 (of 3,479 total)
not much to go on...
what kind of message? Based on what? Service Broker might be a solution.
May 12, 2013 at 1:37 pm
I'm a recovering Access developer, so my opinions may help you (and may well not).
Anyway, Access is good for prototyping and front ends (if you cannot use ASP.NET or VB.NET...
May 7, 2013 at 5:10 pm
This design:
CREATE TABLE #TestTb1 ([Sample_ID] VARCHAR(10), [P1] INT, [P2] INT, [P3] INT, [P4] INT)
is going to bite you. I would strongly recommend not doing that. (I worked on...
May 4, 2013 at 9:40 pm
Wrong design.
CREATE TABLE Test(
PatientID int,
TestID int,
Reading decimal(10,4)
TestDate DateTime
);
Then the rest is trivial.
May 4, 2013 at 5:53 pm
Big topic. You might want to start by looking up partitioning. Do you need to keep some of the records in the table "active"/editable while others are not?...
May 4, 2013 at 5:33 pm
You could also do this in Reporting Services with a Matrix...
April 30, 2013 at 11:10 pm
did you back up and restore MSDB from your old server to the new one? that's where the jobs are stored.
April 24, 2013 at 10:54 pm
Why not split the two types out inside SSIS:
select someData, ISNUMERIC(someData) As NumTest
from test
WHERE ISNUMERIC(someData)=1;
The example is kind of overdone, but the idea is that you can test/filter for whether...
April 24, 2013 at 10:50 pm
It's because they know how to use the Force, and we don't...
Silly Us!
April 9, 2013 at 6:06 pm
Might do that... they have Access and VBA is easy... forgot about doing pass-through queries... Makes a nice front end, but not my favorite as a backend.
March 26, 2013 at 9:24 am
As I understand it (doesn't mean it's right), each salesperson is assigned to one or more geographic areas, and the customers are inside them, so it should be hierarchical. ...
March 25, 2013 at 4:34 pm
That's what I thought... I have no idea how else to do this besides RLS. (Thanks for the warning of how much fun it is... at least now I...
March 25, 2013 at 3:28 pm
I had seen that article before, I'm now I'm walking through it. I noticed that the locations were already geocoded, so that's how the solution works. I did...
March 20, 2013 at 9:57 pm
FWIW, Yuri's code, ProcessAddress() that used Yahoo's geocoding services used to return the County, but that appears to not work anymore.
If I can't get that to work, is there a...
March 18, 2013 at 9:16 pm
what happened when you tried it?
looks like the only thing missing is the ORDER BY clause to force a sort in descending order (so you get the highest values)
March 13, 2013 at 10:47 pm
Viewing 15 posts - 3,361 through 3,375 (of 3,479 total)