Viewing 15 posts - 2,656 through 2,670 (of 3,482 total)
Come to think of it, you might want to look up Doug Steele's DSNless connection code for Access. (Not entirely sure it works for SQL Server, but I don't see...
February 16, 2015 at 3:21 pm
You should be able to relink the tables to SQL Server.
If you use integrated security in SQL Server (so Active Directory handles authentication), you would just have to create groups...
February 16, 2015 at 2:42 pm
now I want to call all the sp on the basis of input like If filename is Fdoor then it shold fire the SP_Archive_using_merge_Fdoor , if file name is Fdoop...
February 15, 2015 at 11:37 pm
February 13, 2015 at 11:17 pm
use a calendar table, omit all the days that fall on Sat/Sun and Holidays. Sort in descending order and return the TOP value?
February 12, 2015 at 11:58 pm
Here's Jeff Moden's DelimitedSplit8K function for doing that.
February 12, 2015 at 11:08 pm
Oh, I thought that's what Jeff's code did. Guess I have more to learn than I thought!
February 11, 2015 at 9:20 pm
February 11, 2015 at 5:27 pm
If it's a one-off, and you have the correct permissions, you can create linked tables in Access that point to the SQL Server destination tables and then run a series...
February 11, 2015 at 5:24 pm
use the ExecuteSQL task to run a stored procedure that accepts a string where you pass what part of the package/packagename and write it to a "log" table in your...
February 11, 2015 at 5:20 pm
Look at Jeff Moden's DelimitedSplit8K function. It basically converts a delimited string to a table that you could use in a join.
February 11, 2015 at 5:17 pm
There's a solution to the gaps and islands problem in Itzik Ben-Gan's book on windowing functions, too. I know I've seen at least one article on the web. Make...
February 10, 2015 at 2:23 pm
If you base the report on a stored procedure (with the parameters already declared), SSRS creates the corresponding report-level parameters for you.
Otherwise, you would have to create your own parameter...
February 10, 2015 at 1:51 pm
Welcome to SSC.
Thanks for the sample data. In the future, if you could post it like this, you'll get a lot more responses, and more quickly because people don't...
February 9, 2015 at 11:15 pm
Wendell,
I'm okay at VBA. I am pretty sure Allen Browne has some code to clone records inside a transaction. The only hard part is retrieving the value of the...
February 8, 2015 at 5:53 pm
Viewing 15 posts - 2,656 through 2,670 (of 3,482 total)