Viewing 15 posts - 1,096 through 1,110 (of 1,183 total)
For future reference, the site below has it all!!
http://www.connectionstrings.com
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 12, 2006 at 5:36 pm
select
right('0' + cast(datepart(month,a.datehired) as char(2)), 2)
+ '/'
+ right('0' + cast(datepart(day,a.datehired) as char(2)), 2)
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 29, 2006 at 4:23 pm
Here is a revised version that works much more efficiently, and addresses various issues with the original version.
---------------------------------------------------------------------------------------------------
USE [ReportServer]
GO
/****** Object: StoredProcedure [dbo].[js_data_driven_subscription] Script Date: 09/29/2006 18:10:40...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 25, 2006 at 6:19 pm
If you can post the code tomorrow, it will be much easier to look into. But you knew that 🙂
~I just posted this reply so that I would get an...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 25, 2006 at 6:07 pm
Give your textbox this value ...
="Page " & Globals!PageNumber & " of " & Globals!TotalPages
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 24, 2006 at 5:40 pm
What about
, SUM( CASE r.packagetransmethodid WHEN 9 THEN ShipmentQty ELSE 0 END) as "Others"
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 22, 2006 at 1:46 pm
Also, if you need appostrophies in your query, you'll need to replace then with ' + char(39) + '
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 19, 2006 at 4:12 pm
Use a parameter to hold the Database name and Use EXEC sp_executesql ...
Make your data source as follows....
DECLARE @strSQL nvarchar(1000)
SELECT @strSQL = 'select * from ' + @dataSource + '.dbo.yourQuery...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 19, 2006 at 4:10 pm
Can you post the query you've written?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 12, 2006 at 5:09 pm
You can not refer to fields in the Header and Footer, however a work around is to use a textbox or field in a table/matrix to hold the value for...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 12, 2006 at 5:02 pm
That's what I thought, but I had to ask.....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 6, 2006 at 7:47 am
I'll go hide in my corner now.....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 29, 2006 at 8:54 pm
This is only a work around, but you could create a "dummy" parameter that isn't used in any of your queries and don't give it a default value.
I haven't tried...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 26, 2006 at 4:54 pm
Thanks Andy. I guess I hadn't thought of that as I developed this to solve an in house need and that wasn't somethingI have to deal with. but that is...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 14, 2006 at 7:33 am
I've been meaning to post this for quite a while, but here's an updated procedure that works much better....
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[data_driven_subscription]') and OBJECTPROPERTY(id, N'IsProcedure')...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 13, 2006 at 5:36 pm
Viewing 15 posts - 1,096 through 1,110 (of 1,183 total)