dwain.c (7/2/2012)

---

ChrisM@Work (7/2/2012)* You still have tables neoset_statisticsLocationTypesLangs and neoset_statisticsLocation_types_jt in your

FROM list, even though neither are referenced in the output, or by any joins, or the WHERE clause....

Just a hunch Les, but have you tried replacing the delete & update with MERGE?

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

-- Delete any previous record from today

-- Close out the previous record

MERGE CollectorTransitionHistory AS [target]

...

Sean Lange (7/2/2012)

---

ChrisM@Work (7/2/2012)

---

Sean Lange (7/2/2012)

---

You will find far better performance and code maintenance by creating a sproc for each of your different select statements. The code dwain posted is...

Sean Lange (7/2/2012)

---

You will find far better performance and code maintenance by creating a sproc for each of your different select statements. The code dwain posted is indeed quite a...

Yep.[/url]

SELECT *

FROM #Sample s

CROSS APPLY (

SELECT ClaimCount = COUNT(*)

FROM #Sample

WHERE [Member ID] = s.[Member ID]

AND [Date of Service] >= s.[Date of Service]

AND [Date of Service] <=...

Ted_Kert (7/1/2012)

---

Is the benefit of OUTER APPLY and CROSS APPLY that you don't need an ON clause? I don't really see why these are different from LEFT OUTER JOIN...

Jigneshal (7/2/2012)

---

MysteryJimbo (7/2/2012)

---

Jigneshal (7/2/2012)

---

Hi,

I want to create a database for hospital management system.

but i dont have much idea to design db. Can anyone help creating db for hospital management.

It will...

mixalissen (7/2/2012)

---

This problem has been bugginh me since friday! After a good weekend I managed to find the solution 🙂

ALTER VIEW [dbo].[neoset_dailySalesManReport]

AS

SELECT distinct TOP (100) PERCENT s.contentid,...

Those two rows with contentid = 1, which have a different furniturelocation: which other columns are different between the two rows?

Avoid using ORDER BY in views. If you check the...

_simon_ (7/1/2012)

---

I want my results to be grouped, your query is totally correct. I was just curious if there is any reason behind the decision, that you used dense_rank() instead...

Using an inline function may help somewhat. Here's the definition of your existing splitter:

--User Defined Function (InLine)

CREATE FUNCTION dbo.Split

(

@RowData nvarchar(2000),

@SplitOn nvarchar(5)

)

RETURNS @RtnValue table

(

Id int identity(1,1),

Data nvarchar(100)

)

AS...

Phil Parkin (6/29/2012)

---

ChrisM@Work (6/29/2012)

---

If you'd said "less than 6" then you would have had alternatives options to a function. With a maximum of about 50 items in the list, then...

If you'd said "less than 6" then you would have had alternatives options to a function. With a maximum of about 50 items in the list, then I reckon you...

Welsh Corgi (6/29/2012)

---

It is a Simple Query. I just wanted to get the record counts right before I added a bunch of CASE Statements.

As soon as I add the first...