Carlo Romagnano (9/1/2015)

---

To get it for each db and files:

declare @sql nvarchar(max) = 'select 0 as dbid,0 as fileid WHERE 0=1'

SELECT @sql = @sql + '

UNION ALL SELECT '''+RIGHT(database_id,10)+''',fileid FROM...

You are very welcome and thank...

Simply add it to the last part of the...

Here is the code again with comments, let me know if you need further explanation.

😎

/* CTE (Common Table Expression for marking the sessions in

chronological order, creating an...

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

DECLARE @SAMPLE_DATA TABLE

(

[action] VARCHAR(10) NOT NULL

,[date] DATE ...

hegdesuchi (9/5/2015)

---

Hey,

thank you very much. It does work.. But I have to repeat this scenario for 3 flags.. So I have to define CTE all three times.

Do we have...

QQ-485619 (9/5/2015)

---

I need some help with the following situation

I have a table with the follow row and sample data

RowID RecordType ...

Looks more like a rounding trick in the insert, pretty certain the column's datatype...

J Livingston SQL (9/5/2015)

---

TomThomson (9/4/2015)

---

Eirikur Eiriksson (9/3/2015)

---

TomThomson (9/3/2015)

---

Ed Wagner (9/3/2015)

---

I would definitely attend your presentation on DBCC Timewarp. However, given the topic, expect some serious heckling. 😉

Those who have...

Quick thought, yes you will have to sum up the quantity, probably similar to the PackageTotals.TotalActualWeight

😎

Although one could try to decypher the query it is unlikely that answers derived from...

Quick thought, make certain that you use an inline table value function and NOT a scalar function, the performance of the latter is horrendous, see the simple test harness and...

jacksonandrew321 (9/5/2015)

---

I need to develop a client side XSLT that can transform that can extract only the required information that should be published e.g. Full name of scholar, department name,...

You are very welcome and thank you for the feedback.

😎

MotivateMan1394 (9/5/2015)

---

No It's not true.

If I Group by Cartid,SHCode , I get all records in my result.

I Need sort of Group BY cartid And get max(editDate) >>> at...

hegdesuchi (9/4/2015)

---

Hi,

I have a scenario where ID has three flags.

For example

ID flag1 flag2 flag3

1 0 1 ...