Initially it was 1 MB. I changed it to 10 MB. Still not working.

By Increase manually do you mean:

1. Right Click on the DB

2. Select Properties

3. Select Files Tab

4....

GETDATE() will retrieve date in the format 2012/02/22 21:23:33.256 (Includes Date & Time). So in your query when u say

FM.Openeddate=getdate() the date match should be exact up to...

Try this :

WHERE CONVERT(DATE,FM.Openeddate)=CONVERT(DATE,GETDATE())

Jeremy... (2/22/2012)

---

I am trying to write a query that pulls our new orders for the current day.

Where FM.Openeddate = getdate()

did not work. ...

Thanks a lot Eugene for your valuable feedback. Will create a table for all dates as advised.:-):-)

Eugene Elutin (2/22/2012)

---

Happy to help!

As I've advised in the previous post, it is a...

Hi Eugene,

Thanks a looooooooooooooooooooooooot !!!!!!!!! for the timely help. Sorry for not implementing your idea of adding the column to query. I failed to understand that part. Thanks again for...

I tried replacing the 0 with '1900/01/01',

=DATEDIFF("WEEK", CDATE(DATEADD("MONTH", DATEDIFF("MONTH","1900/01/01", Fields!EnquiryDate.Value),"1900/01/01")), Fields!EnquiryDate.Value) +1

I get the following error:

The Group expression for the grouping 'GroupName1' contains error: Argument 'Interval' is not a...

Hi,

Your expression works in SSMS:

select DATEDIFF("WEEK", CONVERT(DATETIME,DATEADD("MONTH", DATEDIFF("MONTH", 0, GETDATE()), 0)), GETDATE()) +1

But when I try it in SSRS :

=DATEDIFF("WEEK", CDATE(DATEADD("MONTH", DATEDIFF("MONTH", 0, Fields!EnquiryDate.Value), 0)), Fields!EnquiryDate.Value) +1

I get the following...

Hi,

Let me make clear what my requirement is. I am generating a Weekly report on SSRS 2008 and in the report as shown in the excel file I have to...

Have u set the Email settings in the Reporting Services Configuration Manager.

Hi Stewart,

Can you please show How I can use the Weekday() in the Expression. Tried various options . I am completely lost.

=DATEPART(DateInterval.Weekday, (Fields!InvoiceDate.Value))

Stewart "Arturius" Campbell (2/16/2012)

---

Consider using either

>...

Thank you :-):-):-):-):-) Jared once again :-):-):-):-)

SQLKnowItAll (1/31/2012)

---

You can do this as an administrator of the site. Go to the report you want hidden and alter its security to...

Hi,

I need to get only the data that repeats date wise.

crazy4sql (1/30/2012)

---

Not sure if I understood your requirement correctly, but is this query not helping

select col1,col2,date from tblname order...

Thanks a loooooooooooot !!!!!! Mark for the timely help :-):-):-):-):-):-):-):-):-):-):-)

Thank you Jared !!!!!

If the table is small. U can generate a script to create the table with the data.

For SQL Server 2008 R2 follow the steps:

1. Right Click on the database

2....