This is quite easy when using FOR XML PATH, here is a quick example

😎

USE TEEST;

GO

SET NOCOUNT ON;

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

CREATE TABLE #EmpMaster (EMP_ID INT,Ename VARCHAR(50))

IF OBJECT_ID(N'tempdb..#EmpDetail')...

mah_j (10/29/2016)

---

you will need this index on the dbo.Transaction

CREATE UNIQUE NONCLUSTERED INDEX [INDEX_NAME] ON [dbo].[Transaction]

(

[InvoiceUID] ASC,

[IsSuccess] ASC,

[TransKind] ASC,

[TransactionDate] ASC

)

INCLUDE ( [CardNumber],[ReferenceNumber],[SeqCounter],[UnqReferenceNumber]);

and this index for the dbo.Invoice

CREATE UNIQUE NONCLUSTERED INDEX...

Are there no indices on the table?

😎

Suth (10/28/2016)

---

Hi,

I'm currently trying delete data from a large database with the below code... But its taking quite a long time to delete 1000...

Question, did you try to attach the mdf with ATTACH_REBUILD_LOG?

😎

Quick suggestion, use wildcard for the namespaces

😎

USE TEEST;

GO

SET NOCOUNT ON;

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

SELECT

CONVERT(XML,'<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

<Catalog>My_CAT</Catalog>

<Cube>My_Cube</Cube>

<DbpropMsmdOptimizeResponse>1</DbpropMsmdOptimizeResponse>

...

torrid.inundate (10/28/2016)

---

Still i failed to get desire result.

/*

The following example displays the current date and time, uses CAST to change the current date and time to a character data...

Quick suggestion, use the CONVERT (link to BOL) function to explicitly convert the string values to the datetime data type rather than depending on any implicit conversion

😎

SQLSalas (10/28/2016)

---

Yeps, that was it. I have to flip it and flip it back.

Although it says it was enabled in the configuration, there were 2 traces with...

SQLSalas (10/27/2016)

---

It looks like the default trace is no longer running for SQL 2016. Trace is scheduled to be deprecated but i thought it still is usable for SQL...

hegdesuchi (10/25/2016)

---

I have a scenario where I have to create a replication of a target table along with source Id field.

If I have Target Table with columns :

Target_ID,

name,

createdate which is...

Thanks for the correction Luis!

😎

albanamino09 (10/27/2016)

---

Hello,

I need to round some values in a column, with a step of 30.

For example,

every value from 0.1 to 29.9 to be rounded to 30,

every value from 30,1...

arto.ojala (10/27/2016)

---

There are some CONVERT_IMPLICIT-statements in execution plan when login is Finnish.

I guess this has got something to do by conversions, when having numbers in char or varchar-column, and using...

Brandie Tarvin (10/27/2016)

---

Eirikur Eiriksson (10/27/2016)

---

Brandie Tarvin (10/27/2016)

---

I foresee that question being asked again in the very near...