For that you should send standard format for the dates i.e. yyyymmdd hh:mm:ss.mmm, yyyy-mm-ddThh:mm:ss.mmm OR yyyymmdd (since you do not need time part to be stored). As far as front...

Put single quotes around the dates, while assigning to the parameters and hopefully it will work e.g.

@flp_start_date = '02-02-2012',

@flp_end_date = '02-05-2012',

First glance at the execution plan made me jumped on my chair. The estimated rows to be returned are 1,527,070,000,000 and the estimated rows size is 195,147,877 MB :w00t: Is...

Have you checked the permission of registry key? One of the ways to do so is as follows.

-Run "regedit"

-Go to the registry key

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\SQLServerAgent]

-Right click on the key "SQLServerAgent"

-Select...

To start with this is not a SELF JOIN but an anti-semi-self-join and seems like you can turn it into a semi-self-join(OR JOIN). (I am not too sure if it...

ChrisM@Work (12/1/2011)

---

Usman Butt (12/1/2011)

---

ChrisM@Work (12/1/2011)

---

Use a crosstab, preaggregating the raw table with either a CTE or a derived table. Here's the derived table version:

SELECT

ItemCode,

Column1 = MAX(CASE WHEN YearShipped =...

ChrisM@Work (12/1/2011)

---

Use a crosstab, preaggregating the raw table with either a CTE or a derived table. Here's the derived table version:

SELECT

ItemCode,

Column1 = MAX(CASE WHEN YearShipped = 2010 AND MonthShipped...

There is no need to scan the whole table again and again. You should use CASE to sort this out. Its pretty much simple e.g.

SELECT

ItemCode

, SUM( CASE WHEN...

pandisam66 (12/1/2011)

---

Hi,

First install SQL server 2005 RTM on windows server 2008 R2. Apply minimum SP3 for SQL server 2005 (now SP4 is available). Apply Microsoft visual studio SP1 (atleast) for...

I believe the problem is not with...

Can you please let us know, how those users are connecting to the server e.g. through application, SSMS etc? Moreover, which version of SQL Server are you using?

Is remote connections enabled on the server? By default it is disabled. Moreover, which windows platform are you using for you SQL Server?

Yes, you can install it on Windows Server 2008 R2. But I believe you must have at least SQL Server 2005 Service Pack 3 (SP3) installed. Cheers.

Dev (11/30/2011)

---

Usman Butt (11/30/2011)

---

Dev (11/30/2011)

---

It might be a security issue in SS2K, not any more.

•Members of the securityadmin role cannot make any login a member of...

Dev (11/30/2011)

---

It might be a security issue in SS2K, not any more.

•Members of the securityadmin role cannot make any login a member of the sysadmin fixed server role.

•Members...