This is an interesting one. Please post your solution, Thom, when you manage it (I have confidence ...!)

I've already played around with various Row_Number() ideas to no avail.

Further to Thomas' answer, the flippant answer given by many people here would be 'in the garbage'.

That's because if your table is being updated while a (NOLOCK) query is...

ramyours2003 (12/29/2016)

---

I need to recommend tempdb files how many needs to created , can nay suggest to recommend how many files needs to be there or else...

What do you mean by 'fixed', exactly?

Do you just want to ignore the bad rows, or something more?

An alternative approach to Drew's is to read the file in as a...

guaro5555 (12/28/2016)

---

Hi gurus

I am new to this as you can tell by my postings but trying to get a hang, so go easy on me.

I am looking...

Note also that

CASE WHEN height IS NULL THEN 0 ELSE 1 END

may be shortened to

IIF(Height IS NULL, 0, 1)

Nice, Alan. I saw the word 'split' and I was off like one of Pavlov's four-legged friends. Did not even consider alternatives.

mcfarlandparkway (12/27/2016)

---

Set based approach? How to do this?

How to parse(split) this 9000430944:7|Information

-> 9000430944 - emp number

-- 7 - stud number

--Information - Description

How to split on pipe? and How to...

mcfarlandparkway (12/27/2016)

---

In the stored procedure - I need to implement a loop based logic after update statement ..

Now I have to add a logic in this stored procedure

after update...

mcfarlandparkway (12/27/2016)

---

Hello,

I have data from two different sources - Source1 and Source2 - we have a dtsx package where it loads...

wweraw25 (12/27/2016)

---

Yes you are right. I have a two date fields to compare.

But whats the thing I should do in SSIS to achieve this since it is across different...

wweraw25 (12/27/2016)

---

I'm comparing on combination of keys.

I know lookup is not a good option for millions of rows.

Is there any other way to grab the difference and insert into table...

wweraw25 (12/27/2016)

---

Hello,

I have two tables

-- Table A in Server A of Database A

-- Table B in Server B of Database B

My Source is Table A and Destination is Table...

SQL Prompt to the rescue!

For the benefit of others, here's that query again, with line-breaks :w00t:

SELECT

Account02_ACCOUNT_ID6 ...