yes and yes.

can you share your sample code.

CREATE TABLE [dbo].[tblDate](

[sDateID] [bigint] NOT NULL,

[FullDate] [datetime] NULL,

[DateName] [Date]NULL,

[DateNameUS] [Date] NULL,

[DateNameEU] [Date] NULL,

[DayOfWeek] [tinyint] NULL,

[DayNameOfWeek] [char](10) NULL,

[DayOfMonth] [tinyint] NULL,

[DayOfYear] [smallint] NULL,

[WeekdayWeekend] [char](7) NULL,

[WeekOfYear] [tinyint] NULL,

[MonthName] [char](10) NULL,

[MonthOfYear] [tinyint] NULL,

[IsLastDayOfMonth] [char](1)...

sorry GilaMonster will not cross post again

Thanks all for your answers. They are all helpful

yea it was an interview question?

Yea I have backup, but the question is you cannot even log into the smss to restore your back up.

well i said i will copy...

Datepart()

answered how do I closed this

Ok thanks, what do you suggest? I am using a query builder in bids.

sincerely

Thank you miltman that works.

I guess I have to create a parameter to select

the company name.

Thanks a lot

All I want to do is to get rid of the blank rows in the reopenid column

I have attach a sample of how I want this to be.

I am running...

I want the first column of the attach pdf form just to display only the cell with reopenId numbers. I don't need the blank ceels in the first column

([Reopen ID]...

hi sean i know you have good intent

WHERE (Type NOT IN ('Siu-ai', 'Subrogation', 'Siu-fi', 'SIU', 'Siu-mi')) AND (Company = 'xxx') AND ([Compliant Status] = 'xxxxx') AND

...

No is the same sir, I am trying both t-sql and ssrs expression to see which one will work.

I just attach a copy of my report so that you can...

Oh ok maybe that is why a simple query is turning into something big.

Thanks

I have come a cross this code below

=IIF(IsNothing(Fields!Product.Value),"NO","YES")

Instead of returning both no and yes, I want only yes but

with the open_id