Viewing 15 posts - 22,861 through 22,875 (of 26,490 total)
Henny (1/26/2009)
The best way to go is to break out a large SQL server table into smaller Access databases based off values in the SQL server table.
It depends. What...
January 26, 2009 at 6:49 pm
sqlcool (1/26/2009)
Could u pls help to achieve this.
i need top version on each id as a result
ORIGINAL DATA
id version
1 ...
January 26, 2009 at 6:41 pm
Michael Valentine Jones (1/26/2009)
At the bottom of the main Forums page I see this:
Board Statistics
760,819 members have posted 518,208 posts within 118,891 topics....
January 26, 2009 at 6:17 pm
Jeffrey Williams (1/26/2009)
Lynn Pettis (1/26/2009)
Using SSIS, the process would be encapsulated in a FOR EACH container (not exactly sure how i would configure) and within that I'd have the...
January 26, 2009 at 6:15 pm
Party Time is getting closer! Less than 1500 new subscribers are needed!!!
January 26, 2009 at 5:16 pm
kabolick (1/26/2009)
PersonName
1John
2Jason
3Chris
4David
PersonTotalDistrict
1$50 101
2$75 102
3$90 103
DistrictDistrictName
101North
102South
103Mid-Atlantic
104West
RESULT:
PersonNameDistrictDistrictNameTotal
1John101North ...
January 26, 2009 at 5:10 pm
Before anyone jumps in and does your homework, why don't you show us what you have done so far to solver your problem. This is really an easy thing...
January 26, 2009 at 5:06 pm
Very carefully.
Using SSIS, the process would be encapsulated in a FOR EACH container (not exactly sure how i would configure) and within that I'd have the necessary "code" to connect...
January 26, 2009 at 5:02 pm
If part of that is cost, remember that SQL Server Express is free. Using replication reduces the amount of "plumbing work" you need to develop to put the data...
January 26, 2009 at 4:54 pm
Something else to keep in mind. If you are using a cluster to handle a server failure and a mirror to a separate server (or cluster) using a separate...
January 26, 2009 at 4:47 pm
Both solutions require that software be installed on the users systems. Either SQL Server Express or Access. The difference between the two solutions is simple, who does the...
January 26, 2009 at 4:27 pm
I just thought I'd stop by and see how you are doing with your query and see if need any help.
January 26, 2009 at 4:17 pm
Why is using SQL Server Express not an option?
January 26, 2009 at 4:08 pm
Joe Burdette (11/6/2008)
In MHO, making a change to the underlying table structure is NOT a workaround. (period!) Therefore, the only "workaround" solution is to change the select statement. 😉
No need...
January 26, 2009 at 3:10 pm
Tom.Thomson (1/26/2009)
J (11/6/2008)
No. YOU ARE wrong.
It does not matter if there are duplicates or not, because the question specifically mentioned that there were no duplicates.
So "UNION...
January 26, 2009 at 3:06 pm
Viewing 15 posts - 22,861 through 22,875 (of 26,490 total)