Jeff Moden (6/21/2014)

---

ykonline (6/20/2014)

---

Hi,

I want to insert data periodically from an excel file into a table using a SSIS. But each time the no. of columns in excel may vary....

+#2222CC

😎

Thought it would be Purple, half the time one sees red:blush: and the other half on is feeling blue:(

😎

Mi dispiace,

thought I had answered this long time ago:-D

😎

USE tempdb;

GO

create table #prova

( Valuta varchar(2),

Misura DECIMAL(18,5)

)

insert into #prova values ('EU',1000)

insert into #prova values ('$',2000)

/* Adding a row number */

;WITH DIM_BASE AS

(

...

muthyala_51 (6/20/2014)

---

I am trying to upgrade my 2008 sql server to sql 2014 with windows upgrade to 2012. Just came to know that we are on 2003 Active directory and...

Lynn Pettis (6/21/2014)

---

Here is how I am importing an XML file into an XML variable for processing. The key is the OPENROWSET BULK option. Hope this helps some.

declare...

Jeff Moden (6/19/2014)

---

Eirikur Eiriksson (6/19/2014)

---

Jeff Moden (6/19/2014)

---

My problem is that I really don't understand what you're trying to do. This start out with "counting characters in a string before...

Trick question as there was no trick in the question:-D

Thanks Andy!

😎

Congratulations!

😎

For fun:-D, here is a full shredding code

😎

DECLARE @XORDER XML = N'<?xml version="1.0" encoding="utf-16"?>

<order>

<Product Index="e1e2c499-f9...etc...." ProductID="12">

<Attribute Name="Paper...etc..." />

<Attribute Name="Ink..etc.." />

...

If the data sample is accurate, this can be simplified by using XML and XQuery

😎

DECLARE @String nvarchar(500) = N''

SET @String = N'

Assessed By: Michael Jordan Yagnesh

Reviewed By: Fred Smith

Home Address'

DECLARE...

Now we have the full question, here is the answer.:-D

Your query is missing the FROM part.

😎

--my table payment_details structure is

DECLARE @payment_details TABLE

(

payment_id ...

neethu payal (6/21/2014)

---

my table structure is

payment_id payment_code

1 null

2 ...

pk2dpvp (6/19/2014)

---

Anyone has any suggestions? ^^

I found loads of things but nothing seems to work...

I'm trying to get a link with XML data inside the page into a table but...

brad.mason5 (6/20/2014)

---

One thing I have noticed recently is TSQL is not the best tool to use when it comes to XML. C# is far more efficient at searching and...