etl2016 (3/7/2016)

---

thanks everyone for sharing your thoughts.

I implemented what I need.

Structurally it looks like a RBAR scenario, but, given the situation that, tables being joined T1 and T2 are slim,...

What do you mean "generate 30 columns"?

How should they look like?

A...

Make sure the definition of the clustered index on the table reflects the definition of the intended partitioning.

And all performance issues which you want to resolve with partitioning will be...

bismsit.29 (3/3/2016)

---

Hi Alan,

Thank you very much for replying back so early.

Its sort of a business requirement that's why i want to reuse them also this value can hold till 99999...

bismsit.29 (3/3/2016)

---

Hi All

I want to assign one unique id to each row in a table and the range is from 1 to 99999. there will be a flag for active...

By "perfection" I meant reducing unnecessary reads (your code) rather than...

You have misplaced pieces of your code.

These don't belong together:

...

'</tr>' +

CAST((

IF OBJECT_ID('tempdb..#StockManagement') IS NOT NULL DROP TABLE #StockManagement;

SELECT

STOCKCODE,

CAST(SUM((CASE WHEN TransactionTypeId IN (1, 4, 5, 7, 8, 10, 11,...

drew.allen (3/3/2016)

---

I see no reason to join to a Tally table here. You have to calculate (ID_No-1)/6 anyhow, so just use that as your first group by expression.

You can also...

Glad to help.

You're...

"[ ]" are wildcard characters used in LIKE.

Check BOL for the correct syntax of the operator and see how to use it properly:

https://msdn.microsoft.com/en-us/library/ms179859.aspx

Only thing - for adding rows when you go over 6 ID's per Provider you're gonna need a tally table.

Here I used a Tally table with sequential numbers from 1...

You have almost done everything! 🙂

Just uncomment the last statement and add the missing bit:

SELECT left(PROVID,6) as PROVIDER , LASTNAME , FIRSTNAME , PROVID, ROW_NUMBER() OVER (PARTITION BY left(PROVID,6) ORDER...

Check for what?

What exactly should be the condition?

djj (3/1/2016)

---

ripas (3/1/2016)

---

Hello,

I want to add different table column in original table's computed column .In Biograph_Master_UDF's imagename column I want to add Name_Master.Last_Name+Name_Master.First_Name+BIOGRAPH_Master_UDF.ID_NUM. But When I was trying to...

Orlando Colamatteo (2/28/2016)

---

Sergiy (2/28/2016)

---

It returns exactly the same result as...