forrest77 (4/28/2015)

---

Hi Gail,

Here is the DDL table

ALTER FUNCTION [dbo].[ADMC_DDL_GetUniqueEditLog]()

RETURNS @EditLog TABLE(

Id INT NOT NULL

,EditDate DATETIME NOT NULL

,PlanId INT NOT NULL

,TransId INT NOT NULL

,EntityId INT NOT NULL

,QtyPrior FLOAT NULL

,QtyAfter FLOAT NOT...

forrest77 (4/28/2015)

---

Lynn,

I included some data from the EditLog table in previous post.

I get the following error when creating the function

Msg 4514, Level 16, State 1, Procedure ADMC_DDL_GetUniqueEditLog, Line 25

CREATE...

Nevyn (4/28/2015)

---

Sergiy (4/27/2015)

---

MAC address - is it a string?

By all means - NO!

Compare E8:AB:... and e8-ab-...

These are completely different strings, but they present the same MAC address.

Just another example of...

Really need the DDL for the table(s), sample data as insert into statements, and expected results based on the sample data.

charipg (4/28/2015)

---

I am getting error [[Msg 116, Level 16, State 1, Line 7 .Only one expression can be specified in the select list when the subquery is not introduced with...

peterausger (4/28/2015)

---

thanks lynn,

following is what i want..

2323 (2323 should have childs like 23231000,23232,23233000,232390 as its child))

23231000 ( should have nothing)

23232 (should have 232321,232329 as its child)

23233000(should have 23239010,23239020,23239030,23239040,23239090 as its...

forrest77 (4/28/2015)

---

Hi Gail,

Here is the DDL table

ALTER FUNCTION [dbo].[ADMC_DDL_GetUniqueEditLog]()

RETURNS @EditLog TABLE(

Id INT NOT NULL

,EditDate DATETIME NOT NULL

,PlanId INT NOT NULL

,TransId INT NOT NULL

,EntityId INT NOT NULL

,QtyPrior FLOAT NULL

,QtyAfter FLOAT NOT...

Look carefully at the code below. You have two columns in the select list in the declaration of your cursor.

DECLARE Dropuser_Cursor CURSOR FOR

Select

dbname,

...

I think I see it now:

create table test222(sid bigint, scode nvarchar(50), parentid bigint, sname nvarchar(50));

insert into test222 values (1, '2323', 0, 'iam a boy');

insert into test222 values (2, '23231000', 1,...

peterausger (4/27/2015)

---

------ create table

create table test222(sid bigint, scode nvarchar(50), parentid bigint, sname nvarchar(50))

insert into test222 values (1, '2323', 0, 'iam a boy')

insert...

SQLRNNR (4/27/2015)

---

Lynn Pettis (4/27/2015)

---

How many people...

neeraj-344433 (4/27/2015)

---

@Sean Lange.

I certainly have no intention to ignore anybody who is trying to help me. If thats the message being conveyed, my apologies.

So lets start from beginning ...

And I can't see any way to speed up a query that always returns 100% of the data (columns and rows). Well, you could put the database on SSD...

How many people does it take...

neeraj-344433 (4/27/2015)

---

@SSChampion - At this point, it is basically select * from table. This is table has 85 columns. Why i am saying this is because the query to...