farfel (10/22/2015)

---

I have searched the internet for this situation to no avail, but we believe that starting in some version of SQL2008+ that if you define the @columns variable as...

If you wanted to stay in the past, you could have followed this: https://www.virtualobjectives.com.au/sqlserver/dts_sql2005.htm

eric.notheisen (10/22/2015)

---

Once you cross the border you need to consider that you are on a network controlled by another government. Anything you transmit whether it is email or an web...

Is great to know that you're sharing your real life experience. As commented above, the cross tabs approach has been way back before pivot and is more flexible. That doesn't...

Without actual sample data, I can't ensure that this will work, but it should give you an idea. It reduce the code and the work done.

SELECT [GCM_CLIENT_CD],

...

SQLCurious (10/21/2015)

---

I store my dates as integers (in YYYYMMDD format) and have an index on them. I have another DimDate table that has YYYYMMDD as clustered PK, and the remaining...

Why do you think you need a cursor? You're not even using the variable inside the cursor.

I'm not sure about your requirements as they're confusing and your sample data won't...

As John said, the problem is that your splitter function is at least 4 times slower than the one we suggested. It might actually be worse by using varchar(max).

Read the...

That's even a better reason to stop and understand what you're...

You forgot to create the splitter in your system. You need to use it inside the function and call the function using your table.

Alan, your idea is good, but if order is important a tweak might be needed.

CREATE FUNCTION dbo.RemoveDupes(@string varchar(8000))

RETURNS TABLE AS

RETURN

WITH CTE AS(

SELECT MIN( ItemNumber)...

Why not just drop and recreate the database?

If you can't create data that accurately represents your problem, then you might not understand your real problem or your data.

We can't help you with that and we can't understand...

Brandie Tarvin (10/20/2015)

---

Ed Wagner (10/20/2015)

---

Alvin Ramard (10/19/2015)

---

From: http://www.sqlservercentral.com/Forums/Topic1720717-1292-4.aspx#bm1729123

Oh...

j.sjoelund (10/20/2015)

---

Hi,

I have imported a txtfile to access and have some problem making the data appear in my wanted way. I want to shift the cells in the first row...