This should do it.

select dateadd(dd, datediff(dd, 0, GETDATE()), 0) + CAST('04:00:00' as time)

smharabbani40 (10/11/2013)

---

Hi

MonthYear is the INT data type.that is only the issue ,becuse of that between is not working....i can able to change datatype....

if any suggestion/fixe rather than this please...

Somewhat difficult to figure out what you are trying to do here. I think maybe you are trying to generate a comma separated list of values from the last query?

Take...

And what would the error message say? We can't really offer much help if you don't tell us what...

smharabbani40 (10/11/2013)

---

Hi I need a Query from the month 112013 to 122013 sir......

i have used the below Query which is not satisfieing.

...

One other thing is you might want to read up on NOLOCK. You have it littered all over this query. That hint is not a magic go fast solution. It...

smharabbani40 (10/11/2013)

---

Hi ALL,

I have one table which contines 3 columns they are

1.emp

2.monthyear

3.amount

in that table i am having four rows like below.

emp monthyear amount

1 ...

yogi123 (10/10/2013)

---

Hello

I need to Create a Function who pulls data from string and load to the table. here is sample string

'CHG_FEP_SVC_GRP_ID(1) :: Expected Value = 1 :: Actual Value =...

vigneshlagoons 51204 (10/10/2013)

---

Hi Sean,

I am doing this for SSRS reports. I mean its like when user logs in as CCSG Group these group values should also show up(Site Group, Sales...

thedavegray (10/10/2013)

---

Hi,

that seems to work but...

vigneshlagoons 51204 (10/10/2013)

---

Hi Sean,

This is just fine. Now on top of this. I just want to display LOB Group, Site Group, Service Group for CCSG Group.

EX: If Mike log in,...

You can cheat a little bit here since you just want to add a time datatype to a datetime.

select @DateTime + @TheTime

Here is another way without using the ROW_NUMBER window function.

select top 1 column5 from

(

SELECT [column5], 1 as SortOrder FROM [dbo].[table2] WHERE [column1ID] = 5

UNION

SELECT NULL, 2

)x order by SortOrder

Wow it still pretty tough to figure out what you want as output. I took the liberty of extracting your ddl and sample data here so others can find it...

Junglee_George (10/10/2013)

---

I am getting this error message when the JOIN() in ssrs is used.

[rsRuntimeErrorInExpression] The Value expression for the textrun ‘Textbox96.Paragraphs[0].TextRuns[0]’ contains an error: Overload resolution failed because no...