What's the deal with SQL Server 2008 implementation?
I was talking with a Microsoft representative at PASS and he asked me about our SQL Server 2008 implementation plan.
"I don't have one."
"Why not?" astonished look.
"It's up to my ISV's to certify their applications, and they're not doing it. I have software on SQL Server 2000 still, the ISV's aren't upgrading it and won't support it if I upgrade."
Another astonished look.
"So what can we do to fix that?" he asked.
"I don't know."
I didn't know then, I have a few ideas now.
The problem is that the people who write software that work with SQL...
I've run into this before, I ran into it today, and I'll probably run into it again.
Why isn't there an aggregate function that concatenates strings?
Besides the obvious "string don't get that big" (which I'd manage by manipulating my group by to fit) why not?
Where separator is a varchar that determines what goes between each string (space, comma-space, whatever).
This would be pretty dang handy.