Viewing 15 posts - 2,656 through 2,670 (of 3,480 total)
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
Looks like COALESCE is what you're looking for.
Would be easier to test with a little bit of sample data, though.
February 5, 2015 at 12:42 am
Sorry, I meant to add that part - you can't use COALESCE in SSRS directly. It's a T-SQL keyword and not available in SSRS, so you would have to...
February 2, 2015 at 12:14 pm
Viewing 15 posts - 2,656 through 2,670 (of 3,480 total)