georgheretis (2/12/2016)

---

hi

i am import an Excel to a SQL Server ( using DB>TASKS>IMPORT DTA ...) and so on

i am creating an NEW table called 'aaa' from the Excel

the problem is...

I would say it as "because integrating with Excel sucks that way." It is not technically Excel that sucks, it...

can there be different dates on different rows with the same claim number?

how about some schema and sample data code?

Note original thread is over 11 years old.

what happens if john has more claims with andifferent claim number?

as an aside, it is better to post CREATE TABLE and INSERT statements when asking for help so folks wanting...

Just to clarify,...

That is my understanding as well.

You can achieve the same result using FOR XML but I prefer the way you can write the query using the GROUP_CONCAT approach. I am biased though, I wrote the...

Sergiy (2/11/2016)

---

Orlando Colamatteo (2/11/2016)

---

Sergiy (2/11/2016)

---

Believe me, unfortunately - it's not.

Those who know what...

Welcome, to the site and to the SQL Server community.

Microsoft SQL Server certifications are a great way to get ramped up as the content covers the entire data platform. Studying...

Number 1, read everything Kevin said. Re-read it and ask questions if needed.

Now let's break down the next steps:

1. What program or process is calling this proc? It is important...

Sergiy (2/11/2016)

---

Believe me, unfortunately - it's not.

Those who know what their data types...

wendy elizabeth (2/11/2016)

---

I have the following t-sql 2012, which is the following:

DECLARE @endYear varchar(04) = 2016

select convert(smalldatetime, ('07/31/' + convert(char(02), @endYear - 1)))

select convert(smalldatetime, '08/01/' + @endYear )

that is...

Posting back to a similar problem/topic:

http://www.sqlservercentral.com/Forums/Topic1760478-3412-1.aspx

I have had that happen a couple times. i think it is a bug in this site.

https://support.microsoft.com/en-us/kb/918760