You can create a report parameter then pass that parameter directly to the dataset when called. Or you can create a report parameter then pass that parameter to the procedure...

Can you supply the code from your attempt?

Seems to work fine with this code.

declare @d1 smalldatetime = '1/1/2013', @d2 smalldatetime = '8/31/2013'

select datediff(dd,@d1,@d2)

What everyone else said, shrinking once or twice is okay.

Shrinking a data file causes extra disk fragmentation. This is why you want to size the disk appropriately upon creation to...

So here's what I did to get the results of the dynamic SQL into a variable for further use.

There might be a better way, but this works.

DECLARE @sql nvarchar(2000),

@c...

As Keith said, he must stay healthy. In 2012 he had the most hits in a single season in his whole career, 216. If he can keep healthy then a...

Was watching some baseball shows on MLBTV and I'm surprised that most all the analysts have the Nationals going to and winning the world series. Sure will be interesting to...

Well, who else do I blame for thinking the only way to do it was the clumsy cut/paste method? Surely it can't be myself!

One of those fancy new padded caps they are allowing pitchers to wear this year wouldn't have helped Chapman at all.

Yowza! Poor guy, hope he recovers quickly. Fractured face from...

Anyone else feeling anxious? The first games of spring training are today!

We have a new collision rule in testing as well as new instant replay rules! Can't wait to see...

This can't be emphasized enough.

You should do your best to avoid a bankruptcy, it...

Just saw Fernando Rodney is close to a deal with the Mariners. This makes me wonder, does his crooked hat bother anyone else?

Today marks 2 weeks until spring training! Hooray!

Yeah, the key is that they recognized these problems (over paid long term contract athletes) and resolved the problem before it gets out of control. Signing Crawford was a huge...

The Yankees just won't learn. Stay under the luxury payroll cap, nope. Don't spend tons of cash on older/unreliable/untested players, nope. Recruit for long term success instead of short term...

Meh, I'm still indifferent.

I wouldn't consider myself a purist but I'm not sure what this will bring to the table. I don't think it will make games noticeably longer and...