Viewing 15 posts - 511 through 525 (of 1,079 total)
=iif(Fields!dataset.column.value = "condition", "Green", "Red")
first - focus on the column that will define the result
second - if true colour
third - if false colour
you can have multiple FALSE conditions:
=iif(Fields!dataset.column.value = "condition",...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 20, 2011 at 12:16 am
I fully agree. We have tested on some systems with different configurations, disk speeds etc...and found in some cases the multiple NDF's actually slowed down the processing of some tasks.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 19, 2011 at 11:20 pm
Active.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 11, 2011 at 1:05 am
was this a question/dairy entry/ statement? i dont see the question realy.
anyway, why add all the users as SQL Accounts? they are not linked to AD users.
Rather create an AD...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 10, 2011 at 11:07 pm
its not a compatibility issue, only access..
when logged in as administrator, grant the other account sufficient rights.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 10, 2011 at 11:05 pm
Duncan Pryde (4/13/2011)
Henrico Bekker (4/12/2011)
All 4 options work? one of those questions again...pick 2 out of 4 correct answers...a quessing game again.
Try this:
SET DATEFORMAT ydm
GO
SELECT CAST('2011-04-28' AS DATETIME)
or this:
SET LANGUAGE...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2011 at 12:47 am
All 4 options work? one of those questions again...pick 2 out of 4 correct answers...a quessing game again.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 12, 2011 at 10:36 pm
this might help...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 23, 2011 at 10:13 pm
you can try:
SELECT [column_names_here_instead_of *] FROM sports_program
where tf_org_air_date between ((dateadd(second,[20110304],'1 Jan 1970 02:00'))
AND
((dateadd(second,[20110306],'1 Jan 1970 02:00'))
AND
tf_genre_desc138 like '%basketball%'
and tf_genre_desc137='Sports Event'
order by tf_reduced_titlec
might need some tweaking on the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2011 at 2:52 am
we only exclude mdf, ndf and ldf....but thats only us....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 17, 2011 at 2:31 am
Brent who? 😛
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 17, 2011 at 12:18 am
what are you future predictions based on?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 16, 2011 at 12:38 am
Go to your Reporting Server Configuration (Start, Programs, MS SQL Server, Configuration Tools) connect to the production instance, and verify your Report Manager URL is showing as Production and not...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 15, 2011 at 11:59 pm
Do you receive the alerts in the same time period each day?
Setup a trace in profiler and some perfmon capturing for that time frame to see where and when your...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 15, 2011 at 11:54 pm
GilaMonster (3/15/2011)
In clustering the two nodes should be identical. That's hardware, OS, drivers, etc. Clustering a physical box with a virtual is definitely not having two identical nodes.
Correct, although a...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 15, 2011 at 3:38 am
Viewing 15 posts - 511 through 525 (of 1,079 total)