Luis Cazares (3/25/2014)

---

Assuming you have @@DATEFIRST = 7, you could use this formula:

SELECT CASE WHEN DATEPART(DW, DATEADD( MM, DATEDIFF(MM, 0, GETDATE()), 0)) = 2

THEN DATEADD( DD, 4, DATEADD( MM, DATEDIFF(MM,...

Hi Nevyn,

Don't care of holidays. Just caring about Saturday and Sunday.

Thank you Hunch, The query you have given is here is really nice one.

Thank you Chris. It worked. First query is much better than second query.

Steven.Howes (3/13/2014)

---

The site settings is a link at the top right of the report manager web page. When you go to view your report what's at the top right?...

sqlbuddy123 (3/13/2014)

---

Charmer (3/11/2014)

---

Hi Firends,

I am just a beginner in report service. I am trying to deploy a report. But i get the messages below.

"Error1The permissions granted to user 'Domain\user' are...

Hi Steve, I am not...

yes, I am just a user not Admin.

Hi Nandu,

It worked in visual studio. I am able to deploy through Sql server data tools. But when i tried through web browser, it is keep on giving me this...

Ok Koen, Thank you for sharing this.

Koen, suggest me what should I do ? I did not rename the server. Assume that i had renamed the server, what would I do for that? explain me those...

No Koen, I did not rename anything.

Create FUNCTION [dbo].[GetDateTime](@Date varchar(8), @Time varchar(6))

RETURNS datetime

WITH EXECUTE as CALLER

as

BEGIN

DECLARE @FullDttm datetime

If

(@Date = '0' and (@Time = '0' or @Time = '000000')) or (LEFT(@Date,6) = '190000' and LEN(@Date)...

Thanks to Pete and Abu...Those scripts really works....

Friends...some times i see the date comes in different order....For Ex: instead of 20100225, it comes like 02252010..So my function get failed...Do we...

Terry300577 (1/2/2013)

---

before each load of data set a variable say (RowsLoaded) to -1 or some arbitrary value then use a rowcount and assign the value to the variable when loading...