You don't need to go through each store with a while loop. You can remove all duplicates at a time. There are several ways to do this and the best...

There's no need to do a previous conversion to datetime if this is a one time extraction as SQL Server will do an implicit conversion.

WITH SampleData AS(

SELECT CAST( '2013-12-30 12:09:00.123'...

You're welcome.

Do you understand why did it work? You need to understand it to make any further modifications.

OCTom (12/29/2013)

---

I was thinking hard about a SQL memory from 2013 that was worthy of mention. I had that happen Friday night. I have been tutoring a 10 yr old...

The easiest way would be to do as you say, I'm not sure if there's some way around.

CREATE PROCEDURE CallingProcedure

(

@StartDate date,

@EndDate date,

...

Here's a code to show you how can it be done. You might need to fix it.

DECLARE @dbname sysname

CREATE TABLE #counts( totalcounts int)

DECLARE DBs CURSOR FOR

SELECT name

FROM sys.databases

WHERE database_id >...

I've seen it a lot of times and it...

If you have problems with pivot, you should try the method I posted earlier. It's even better when you need to pivot several columns. You'll find information in the link...

Do you have a WHERE clause in your query using a column from table B?

That might be the issue. If you do, change it to the JOIN clause.

You didn't need to open a new thread. You could just post this on the previous one.

Here's an example, but don't blame me if it doesn't work as you want...

I'm helping here for free.

If you want simple examples, you can press F1 and find examples on PIVOT. Or you can click on the "useless" link I provided to...

You could read this article to find out how to work with CROSS TABS.

http://www.sqlservercentral.com/articles/T-SQL/63681/

For a coded answer, please read the article linked in my signature to now what we need...

You're welcome.

But, do you understand how it works?

What you're trying to do is explained on this article. http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Read it and check the solution.

SELECT customer_id,

all_emails = STUFF((SELECT ' -- ' + email_text

FROM emails x

WHERE x.customer_id = e.customer_id

FOR XML...

vladisaev@hotmail.com (12/26/2013)

---

Without looking at details/specifics,

you can try to get a 'blind' performance gain by using @Table table type variable instead of

#temporary table. You can gain performance improvement...