Viewing 15 posts - 1,036 through 1,050 (of 1,183 total)
🙂
http://www.sqlservercentral.com/columnists/jselburg/2824.asp
______________________________________________________________________
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. SelburgMarch 20, 2007 at 4:52 pm
My experience with SQL Prompt has been nothing but excellent. Granted our production DB has about 500 procedures and only 100 tables and 50 views, but it works very well.
I'm...
______________________________________________________________________
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. SelburgMarch 15, 2007 at 8:05 pm
Jeff,
*laughs* ....
Yes, but this was posted in the 2005 forum as well so I had to submit it here as well. 😀
______________________________________________________________________
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. SelburgMarch 14, 2007 at 9:59 pm
CREATE TABLE #tmp (yourField varchar(100))
INSERT INTO #tmp (yourField)
select 'Val1'
union all select 'Val1'
union all select 'Val1'
union all select 'Val1'
...
______________________________________________________________________
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. SelburgMarch 14, 2007 at 6:18 pm
Basically put, in the Color property box of the control you want to control put ...
=IIF(IIF(Fields!yourFieldName.Value="N/A","Gray",IIF(Fields!yourFieldName.Value<0,"Red","Black"))
______________________________________________________________________
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. SelburgMarch 14, 2007 at 6:14 pm
Another tricky solution is to use some fields/cells in your table. Basically what you do 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. SelburgMarch 14, 2007 at 6:10 pm
I humbly submit this link to my article. This is one methiod that allows you to name and manage your subscriptions, as well as adding the ability to have Data...
______________________________________________________________________
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. SelburgMarch 14, 2007 at 6:06 pm
Look into "Custom Code"
http://www.odetocode.com/Articles/130.aspx
I think this is exactly what you need.
______________________________________________________________________
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. SelburgMarch 14, 2007 at 6:01 pm
I know this is a SQL 2000 forum, but here's the 2005 solution....
CREATE TABLE #tmp (yourField varchar(100))
INSERT INTO #tmp (yourField)
select 'Val1'
union all select...
______________________________________________________________________
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. SelburgMarch 14, 2007 at 5:53 pm
Use..
execute procedure t1 @fiscalyr, @beg_site, @end_site
and make sure that your parameter names in the report are named fiscalyr, beg_site and end_site.
______________________________________________________________________
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. SelburgMarch 8, 2007 at 4:59 pm
The code in the article has been updated, sorry about that.
______________________________________________________________________
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. SelburgFebruary 14, 2007 at 11:36 am
select d.dept_id, d.dept_name, d.[name] from dept_heads d inner join emp_names e on d.[name] LIKE '%' + e.[name] +'%'
______________________________________________________________________
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. SelburgFebruary 7, 2007 at 2:44 pm
select rtrim(Address1) as Address1 from .....
______________________________________________________________________
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. SelburgFebruary 6, 2007 at 4:07 pm
You might find this article both interesting and helpful.
http://www.sommarskog.se/dyn-search.html#Umachandar
______________________________________________________________________
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. SelburgFebruary 6, 2007 at 4:05 pm
FYI, when you reference a column from the LEFT JOIN'ed table in the WHERE clause it creates an INNER JOIN.
This is another way to handle it ....
SELECT
empper.first_name
______________________________________________________________________ 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.
February 1, 2007 at 6:17 pm
Viewing 15 posts - 1,036 through 1,050 (of 1,183 total)