Ed Wagner (3/12/2016)

---

Eirikur Eiriksson (3/11/2016)

---

Very quick on Azure, only caveat...

Baggages?

😎

Can you please post the DDL (create script for the tables), sample data as insert script and the expected results?

😎

Very quick on Azure, only caveat is that it simply...

TomThomson (3/10/2016)

---

Quite interesting. Some of it extremely expressive. Certainly backs up what Gartner recently said...

SQL!$@w$0ME (3/9/2016)

---

When I have an insert and update trigger on the same table, the Insert trigger is triggering the Update trigger to execute since I use UPDATE statement in the...

Trigger

😎

Eschergoedel (3/8/2016)

---

I can't thank you enough for your help, both of you. The term inline schema opened up a lot of effective googling and thus learning for me. Thank you...

The default constraint will only mark the date/time of...

You are very welcome.

😎

This should get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TXML XML = '<Document>

<xs:schema elementFormDefault="qualified" targetNamespace="http://www.dummy.com/Export" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:mstns="http://www.dummy.com/Export" xmlns="http://www.dummy.com/Export" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element msdata:IsDataSet="true" name="Document">

<xs:complexType>

...

Could you please provide DDL (create table), sample data (as insert script) and expected output from that sample?

😎

astrid 69000 (3/7/2016)

---

I know what the problem is now, I am supposed to get a full path and somehow I am not getting it even though they say is being...

astrid 69000 (3/7/2016)

---

Thanks, but that is not what i need.

I need to make a table with columns that contain the values of each one.

and the source is a table...

BEGIN and END are your friends:-D

😎

if (select count(0) from CGL) = 0

BEGIN

dbcc checkident ('CGL', RESEED, 0)

END

else

BEGIN

declare @lastc int

select...