wdmm (5/2/2016)

---

pietlinden,

Included in the original post:

--tblOrder

--Keysv

--72apple

--72orange

--73100

--73100

--desired end results

--idd

--7Value of apple 100

--7Value of orange 100

Below are the create and insert stmts:

--table create

CREATE TABLE [dbo].[tblOrder](

[Key] [int] NOT NULL,

[varchar](50) NOT...

Jeffery Williams (4/30/2016)

---

No I am not sure I following what you are suggesting here or I am missing the point.

So I build a dynamic query. In this case it is...

Brandie Tarvin (4/29/2016)

---

Chad Crawford (4/29/2016)

---

Reminds me of the strip that showed up on my Dilbert calendar this week:...

Alan.B (4/28/2016)

---

Something like this would not work:

CREATE TABLE LovelyTable(

Join varchar(50)

)

SQL Server is generally very good at dealing with reserved keywords as column names but its a terrible practice. Column names...

Brandie Tarvin (4/29/2016)

---

Umm, that won't work. SSMS has the memory limitation. Not my desktop.

Per Microsoft:

Note SSMS is a 32-bit process. Therefore, it is limited...

Ed Wagner (4/28/2016)

---

Lynn Pettis (4/28/2016)

---

I think it is time for me to take a break.

People can't format their code to make it readable, can't post enough information to really help...

Learner44 (4/28/2016)

---

Because we do this exercise every week splitting one table into 4. So when we do this we don't care about what's in there into those 4 tables so...

Learner44 (4/28/2016)

---

Looks like that error is solved and got the new one! Neverending!

Error message

Invalid column name 'cindex'.

SP

ALTER PROCEDURE Doc124NEW_new (@DMIGRATIONNEW nvarchar(255))

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result...

I think it is time for me to take a break.

People can't format their code to make it readable, can't post enough information to really help them with out guessing...

Jeffery, You said you recreated the problem with another table and some test code. That is what I want to see, not the code and table from the...

Learner44 (4/28/2016)

---

I am getting following error.

Msg 245, Level 16, State 1, Procedure Doc124NEW_new, Line 36

Conversion failed when converting the varchar value 'SELECT TOP (' to data type int.

Here is my...

wdmm (4/28/2016)

---

I've placed data into a temp table as such:

declare @i as int

declare @nmbrRow as int

declare @dM table(dM varchar(max))

insert @dM (select lname from names etc..)

set @nmbrRow = (select count(*) from...

It depends. The best you can do is test the different options and...

So what is the issue? You have given us the code but told us nothing else about the problem.

Jeffery Williams (4/27/2016)

---

I know it is something with a server setting or something, not code.

Made another table varchar(8000)

I inserted few hundred characters then just did update where field = field...