Gangadhara MS (5/13/2014)

---

Thanks for your suggestions.

One more help on the same line but here i don't have any SARGble function here its direct select and insert. As i am...

isuckatsql (5/13/2014)

---

lol ..... and so we go full circle.

I started with a dynamic SQL query, too slow.

Then i went with an SQL Indexed View, much faster, but the more items...

To do this...

Gangadhara MS (5/13/2014)

---

Hi Lange,

It Really helps me, I just changed the where clause as mentioned in your suggestion the query reduced to 1 minute from morethan 20 minute, you...

jdasilva (5/13/2014)

---

Will try that. Found the Criteria window (right click the View and select DESIGN)

man, this interface is not very user friendly... Well I guess when it comes...

No clue if this will work but the code will at least parse correctly.

SELECT DISTINCT dbo_StaffListings.LocCode, dbo_StaffListings.AutoNumber, dbo_StaffListings.OfficeNumber,

dbo_StaffListings.[Column], dbo_StaffListings.Floor, Left([dbo_StaffListings].[LastName],1) AS Heads,

dbo_StaffListings.LastName, dbo_StaffListings.ShowName, dbo_StaffListings.FirstName, dbo_StaffListings.Extension,

Len([dbo_StaffListings].[Extension]) AS ExtLen,...

Gangadhara MS (5/13/2014)

---

Hi Experts,

I was Tuning a query which is running for a long time of more than 30 min.When i look at the query i could see its...

You're welcome. Glad that worked for you.

You can use Row_Number with partition...

with SomeData as

(

select 12345 as TransactionID, 129172 as Line_id union all

select 12345, 1654572 union all

select 12345, 56229172 union all

select 12345, 13456 union all

select 12345, 22342...

skb 44459 (5/13/2014)

---

Here is the actual code. I was able to get the resequence using the ROW_NUMBER function. But now I need to get the Parent ID which will point...

LOL. tripleAxe AND gbritton1 posted while I got pulled away. 🙂

--edit--

I missed the tripleAxe post in my first reply.

lbrady (5/13/2014)

---

Hi all,

Here's my situation:

Large design flaw, I know, but we have a table with a varchar field which contains alpha - numeric values. I need to...

skb 44459 (5/13/2014)

---

I have table with data like this, which gives me a tree structure using parent ID.

Seq ParentID Description

---- -------- -----------

1...

Meatloaf (5/13/2014)

---

Is there an easy way to convert Access Queries to SQL Views without doing it manually?

I have used the Databse tool to migrate tables, but cannot see to find...

Interesting. The only actual difference was in the partition predicate of the ROW_NUMBER function. Without having POLICY_DETAILS_ID it adds a very expensive sort to the execution plan. Not sure...