Which works?

kyle.freeman (6/11/2012)

---

In a situation like this, I would have a separate copy of the database on the server, if disk space allows, and point your test environment to this for...

Just an FYI regarding the code above, it won't work if ProdPath is null, unless NULL is a valid return value.

Evil Kraig F (6/11/2012)

---

You can load between ranges, which is what you're looking for, but not by row#, that's a construction meant for our sanity, not for use. You...

krypto69 (6/11/2012)

---

Thanks Lynn.

That is exactly what they are doing.

Anything I can do to help them?... Other than "not supported too bad".

And

Do you know of any documentation I can use to...

Starting with what ColdCoffee did above, I came up...

polkadot (6/11/2012)

---

No, I am getting error:

Msg 537, Level 16, State 2, Line 1

Invalid length parameter passed to the LEFT or SUBSTRING function.

even if I go

SELECT CASE when CHARINDEX('/',...

polkadot (6/11/2012)

---

No, I am getting error:

Msg 537, Level 16, State 2, Line 1

Invalid length parameter passed to the LEFT or SUBSTRING function.

even if I go

SELECT CASE when CHARINDEX('/',...

sivag (6/11/2012)

---

AND ALSO TELL ME IF I ADD ANOTHER COLUMN AS VAR CHAR (10) DATATYPE

CREATE TABLE [dbo].[tblPlotInfo](

[ProjectId] [int] IDENTITY(1,1) NOT NULL,

[PtId] VARCHAR(10) NOT NULL,

[DimensionA]...

sivag (6/11/2012)

---

THIS IS THE TABLE

CREATE TABLE [dbo].[tblPlotInfo](

[ProjectId] [int] IDENTITY(1,1) NOT NULL,

[DimensionA] [decimal](4, 2) NOT NULL,

[DimensionB] [decimal]((18, 4)) NOT NULL,

[DimensionC] [decimal](4, 4)) NOT NULL,

[DimensionD] [decimal](4, 2) NOT NULL,

[ActualPrice] [decimal](18, 2)...

First, take a CLOSE look at your CHARINDEX in your case statement. Second, you need an ELSE in your case statement.

Try the following:

SELECT d.ProdPath

INTO #TestTable

FROM (

SELECT 'Beverages\Soda Pop\Mountain Dew'...

You should probably rewrite your stored procedure to return a range of ids, using a cursor in a trigger is not the best way to process data.

Here is a rewrite...

Cleaned up your code and fixed some data types based on the sample data you were trying to insert.

CREATE TABLE [dbo].[tblPlotInfo](

[ProjectId] [int] IDENTITY(1,1) NOT NULL,

[DimensionA] [decimal](4, 2) NOT NULL,

[DimensionB] [decimal](18,...

WayneS (6/11/2012)

---

Okay, so I've been pretty busy lately. And I just got back from going on the "SQL Cruise". Friday I was up to Philly for SQL Sat. And I...

SQLKnowItAll (6/11/2012)

---

tamil.selvanmca (6/11/2012)

---

CardNo DateTime GateEntry

00000002012012-06-1108:34:23MainGateEntry-Big

00000002012012-06-1108:38:30FF LAB-8 Entry ...