Sebastian Zeller (8/7/2014)

---

If I understood your question correctly, this is likely also a solution you might consider -> Converting a delimited string of values into columns

(If not it's at least...

Hey there!

It'd be great if you could have a read of this (http://www.sqlservercentral.com/articles/Best+Practices/61537/)[/url], then set up some sample data, DDL and...

With the limited information you've given us to go on here, maybe parameter sniffing issue?

Take a look at this three part blog post: -

Part 1[/url]

Part 2[/url]

Part 3[/url]

---

--EDIT--

---

Ah, I'm too slow,...

PFlorenzano-641896 (8/4/2014)

---

Hello,

I'm trying to divide two values from separate rows. Each row is a separate UNION statement.

2014-08-03 00:00:00.000NKBB (N) - Total Offers ...

DiabloZA (7/16/2014)

---

Hi Cadavre,

Thank you so much for ALL your help and time in helping me with this issue, God bless you..

I left out a BIG piece of information that the...

"All the replies" suggests that there were more than one. There wasn't. I replied, then you...

Excellent. One little issue, I can't see how "HOURS" could be an INT, judging by the...

Hey there,

I suspect that the reason no-one has helped you yet is that we don't have any data-types to marry up your sample data with and you haven't explained how...

What have you tried?

First, let's stick your XML in a variable so that we can play with it: -

DECLARE @XML XML = '<HOTEL>

<SEQNO>1</SEQNO>

<GRADE>5</GRADE>

<PRODUCT>H</PRODUCT>

...

Why does it need...

Also the definition of OtherTable please.

ralu_k_17 (7/4/2014)

---

Thanks for the reply!

I have specified CODEPAGE = 'ACP' and I am trying to import into a varchar column, but I modified it to a nvarchar column also to...

ralu_k_17 (7/4/2014)

---

Hello,

I am trying to insert a csv file into a table using Bulk Insert , but all special(french) characters are not inserted correcly.

Is there a specific code page for...

info 58414 (7/4/2014)

---

I have this Date Values ??(DateFrom, DateUntil) selected, which lie in the current Date Range - or in the future.

Now I would like to have:

- If getdate ()...

Newcomsas (7/4/2014)

---

Hello,

I have got two user-defined functions: fn_Top and fn_Nested. The first one, fn_Top, is structured in this way:

CREATE FUNCTION [dbo].[fn_Top]

RETURNS @Results table...