RVO (11/4/2013)

---

Thank you for a quick response.

This is how I call procedure:

EXEC UnitPricingTrans

@P_PER_START = 201308,

@P_PER_END = 201309,

@P_CO_CODE = '7001',

@P_UNIT_TYPE = 'VEH',

@P_UNIT = 'AUSMV'

And I always run it with the same...

RVO (11/4/2013)

---

I compiled a stored procedure (UnitPricingTrans) 3 days ago.

The first execution took 10 min.

When I ran it second time it took 7 sec.

All other runs on that day took...

roy.tollison (11/1/2013)

---

Got the insert part going just trying to figure out how avoid duplicate error.

i have figured out how to avoid for a single column unique index but how do...

TJT (11/1/2013)

---

Hi,

I am trying to change the date format from "2012-06-02 12:25:32.393" to "2012-06"

SELECT Mydate, CONVERT(VARCHAR(7),MyDate, 120) As NewDate

FROM MyData

This works, but NewDate is not in Date Format. ...

malcolm.garbett (11/1/2013)

---

Sean Lange (11/1/2013)

---

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO...

Take a look at this article.

http://technet.microsoft.com/en-us/library/ms189849.aspx

Then scroll down and read about lock escalation. That should answer your questions pretty well.

halifaxdal (11/1/2013)

---

Declare @SVPID int

Set @SVPID = 0

Select SummaryTitle =

Case When @SVPID = 0 Then 'All SVPs' Else Division End From ITSDivision Where ID = @SVPID

This should has nothing...

SQLRNNR (11/1/2013)

---

The Dixie Flatline (11/1/2013)

---

Stefan Krzywicki (11/1/2013)

---

SQLRNNR (11/1/2013)

---

The Dixie Flatline (11/1/2013)

---

SQLRNNR (11/1/2013)

---

The Dixie Flatline (11/1/2013)

---

SQLRNNR (11/1/2013)

---

[font="Wingdings"]How sure are...

craig1768 (11/1/2013)

---

This may be off subject but we wrote a cheater method to handle when you need to pass in multiple parameters to a function

or proc. Sometimes its not...

It is quite simple. Don't do this in the same batch.

IF OBJECT_ID(N'dbo.mtzcus_2014_CoreMenuReportCriteria', N'U') IS NOT NULL

DROP TABLE dbo.mtzcus_2014_CoreMenuReportCriteria;

CREATE TABLE dbo.mtzcus_2014_CoreMenuReportCriteria

(

MeasureType VARCHAR(20) NOT NULL

,MeasureOrder TINYINT NOT NULL

,ObjectiveNumber VARCHAR(3) NOT NULL

,ObjectiveName VARCHAR(100)

,CriteriaCertificationNumber...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

The case expression does not limit the rows that are returned, it is used to determine the value for a given column. If you want to eliminate duplicates a case...

GilaMonster (10/30/2013)

---

I remember seeing a CV where someone had rated himself 10/10 on 4 versions of Windows (XP, 2000, 98, NT4), two versions of SQL Server (2000, 2005) and a...

m.dunster (10/30/2013)

---

Hi,

Wondering if anyone has an elegant solution to finding out how much time has elapsed for a specific hour.

declare @t as table (ptr int identity, START time, ENDD time)

insert...

Stefan Krzywicki (10/29/2013)

---

Sean Lange (10/29/2013)

---

Ed Wagner (10/29/2013)

---

Sean Lange (10/29/2013)

---

Chad Crawford (10/29/2013)

---

We use the scale of 1-10 to help give us an idea of how tough to start the interview...