A while back, I learnt of the (possibly apocryphal) story of Steve Jobs who, during the development of the original iPhone, was demanding that the software engineers reduce the boot...

MS needs to improve the performance of the Format command - a Convert(101) makes NO sense when reviewing code for date formatting problems - unlike the format which...

The question was what should replace xxx in " SELECT 'xxx', ... ".

There are already quotes around the xxx.  Why would I include another set of quotes around the...

• This reply was modified 5 years, 1 month ago by  Ryan C. Price.

I take it that your Visual Studio plugin talks to a web service that you're hosting, and that it sends the SQL code up for conversion?

And I assume...

The author conflates, among other things:
1) relational database theory,
2) SQL (the language)
3) relational database *management systems*
4) applications/frameworks that use these RDBMS's

Horses for courses.

I would say 'it depends' on, amongst other things, your scale, your mix of servers/instances, your job function and experience.

I find truly ironic, this "Text...

fregatepllada (5/26/2015)

---

Ryan, IMHO Filestream does not complicate life - it provides a dual view on BLOBS (the best of 2 worlds) when BLOB could be stored as a file but...

and

Don't know that you'd want to, but maybe mass loading a whole bunch...

Unfortunately, the computer industry is full of organisations that suffer from NIH (not invented here) syndrome.

So if one company comes up with a good idea (in this case, Sybase/Microsoft and...

Jeff, challenge accepted.

something like this?:

create function [dbo].[fn_callist](@startdate date , @enddate date)

returns table as

-- CTE Tally table from http://www.sqlservercentral.com/blogs/never_say_never/2010/03/19/tally_2D00_table_2D00_cte/

return

WITH

t1 AS (SELECT 1 N UNION ALL SELECT 1 N),

t2...

That's exactly...

It took me a while before I could read the article past where we generate XML with attributes and then transform it using a style sheet.

Maybe I'm missing something,...

Joe,

I would have responded sooner, but I've spent a couple of days looking after some other clients, and away from this project.

Firstly, thanks for taking the time to actually respond...

Just want to add my thanks to Jeff.

This article helped me solve my own, slightly similar problem (@ http://www.sqlservercentral.com/Forums/Topic1196820-391-1.aspx )

Mine is a bill of materials problem, and involved adding up...