wendy elizabeth (10/6/2016)

---

This is only a one time update. I am sorry I did not mention that earlier. I basically just need to place existing data into the tables...

We must be talking...

justinricardo016 (10/6/2016)

---

This is the site that anyone who is interested in learning more about SQL server 2005 should care enough to visit. I admire the way that members of this...

marc.corbeel (10/6/2016)

---

Yes but here you include the complete select command in the condition.

Problem is here that my real query is very complex (about 40 lines), and putting it 2 times...

pushkarna.anuj (10/5/2016)

---

Hello,

Let's say we have two tables A and B. Both tables have From Dates .i.e. A.FromDate and B.FromDate and both can be joined on MemberID. I need to pull...

"However I want the lockID value in the locker table to be the same value in the Lock

and the LockCombination tables. Basically I will create rows in the locker...

drew.allen (10/5/2016)

---

With my first article for SSC accepted for publishing, I've already written a second (unrelated) article. I'd like to have a couple of people review it.

This article is...

-- Collect the 12 values of ST.PerformanceConfigChoiceID

-- for the rows where FK1.DestinationID is NULL.

-- Probe the ETLCorrelation table for those rows:

SELECT FK1.SourceTable, FK1.BatchID, FK1.SourceID

FROM [ETL].[dbo].[ETLCorrelation] FK1

WHERE FK1.SourceID IN...

The next step would be to post an execution plan here, as a...

sanjaydut26 (10/2/2016)

---

Here is the function...

ALTER FUNCTION [dbo].[ufn_GetHcmDesignFields]

(

@ModuleId bigint, -- HCM_DESIGN_FIELDS moduleid with IsExtendable status 1

@RID bigInt -- table rid

)

RETURNS nvarchar(max)

AS

BEGIN

DECLARE @Return...

I'm sorry, I don't know the answer to your question - however, Googling revealed this interesting teaser written by Paul White. You may well find pointers (pun intended) to your...

Jeff Moden (10/3/2016)

---

The Dixie Flatline (10/3/2016)

---

While we're on the subject, does anyone know of a reason there could be a performance hit from doing all these cross applies? ...

nazirulfitrifauzi (10/4/2016)

---

SELECT 'KESELURUHAN' AS STATE,

'KESELURUHAN' AS BRANCH,

dbo.uf_get_koddana(h.funding_scheme) AS Dana,

Count(*) AS cnt_all,

Sum(h.approved_limit) AS sum_all,

Sum(isnull(w.wo_amt,0)) AS sum_wo,

Sum(isnull(RECOVERED_AMOUNT,0)) AS sum_wb,

Sum(case when bulantgkbil >= 7 and h.account_status not in (1,9,15) then 1 else 0...

moranamon (9/30/2016)

---

Yes, but what about other entities?

you can't store FKs from difference entities in the same column in Photos, that's the reason why i created the link table from the...

BLOB_EATER (10/3/2016)

---

HAHA. that is actually...