Matt's solution has a problem. If the first row has col3=1, it will be omitted. The issue stems from finding the break points so if the first item...

you should stop converting the numerators to numerics and use floats instead. ideally the app that's consuming this data should format the number, but if that's not possible, then...

skipping input rows is a classic symptom of a mismatch between the number of fields in the table and the data file.

open the .csv file you provided in...

you just need to append the new keyword(s) to the existing criteria.

first pass:

AND freetext((Title,Description),'FORMSOF (INFLECTIONAL, "adi great" OR "Video")')

next pass:

AND freetext((Title,Description),'FORMSOF (INFLECTIONAL, "adi great" OR "Video" OR "night life")')

try this

create table #data ( propertyId int, segmentNum int,

useCode varchar(8), price money, frontage decimal(8,2), acerage decimal(8,2))

insert into #data

select 1, 1, 'A', 16000, 75, 1.25 union

select 1, 2, 'A1', 7000,...

you can define a parameter to allow null values or default values. thus the report can execute without supplying a value in which case the if logic i provided...

what you need sounds straightforward but without your sql it's hard to suggest an appropriate solution. something like this may work:

if (@parm is null )

select @parm =...

I'm confused. A SSRS matrix can automatically generate subtotals for each row/column group. Why won't...

please post a sample of the desired output. it's hard (for me) to understand what you want.

the function body can be replaced with a single select.

CREATE FUNCTION [dbo].[ufn_SubDomScore_MC] (

@pInput VARCHAR(1000), @SUBDOMAIN VARCHAR(100),

@Grade VARCHAR(5), @Subject VARCHAR(5),

...

something like this will do it:

select ColA,

...

0x00000000000140A7 is a number in hex notation. don't enclose it in quotes.

Select * from mytable where timestampcol = 0x00000000000140A7

here's a function that will help:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER function [dbo].[fListToVarchars]( @list varchar(max), @delim varchar(6) )

returns @returnTable table

( item varchar(255) not null, itemSequence smallint not null )

as begin

declare...

XML processing to the...

that's why you'll either have to use the viewer control in your own app, or create a custom control to collect those parameters.