Seems to me several rows in table B match a row in A so the A row would be set three times. Without an ORDER BY there is no...

It is possible to make a big, fat, ugly function with a CASE of selects from all tables in your database. I've done it in a pinch and it...

declare @t table (test varchar(20));

insert into @t values ('abc.def'),('three.four'),('12345.67');

select LEFT(test,charindex('.', test)-1)

from @t

Looking at the history, Microsoft added Tables as a return type in 2005. They added user-defined table types in 2008 so maybe Microsoft never went back extend the grammar....

declare @s varchar(20);

set @s = 'October 2013';

select REPLACE(@s,' ', SPACE(20 - LEN(@s)))

returns:

October 2013

The question is basically flawed because for now we are stuck with the Von Neumann architecture in our business computers where everything is single-threaded through the CPU in charge. ...

A connection can't really multitask; the question is flawed. Sqlserver is quite like its own mini multitasking OS in that it implements its own round-robin task switching. To...

I would argue space-time is made of two mutually dependent mind illusions that there is finite space and finite time. Reality is infinite. Teach kids in second grade...

Nice! It seems like a strange request but I get it often. The boss generally wants a few exact match clauses and a subset of several "fuzzy match"...

The Database Diagrams support in SSMS is pathetic. VISIO is uber pathetic. I NEVER want to edit a schema in the diagram and I ALWAYS want to print...

I suspect this is your problem. There is also a size setting in Management Studio.

-y display_width

Sets the sqlcmd scripting variable SQLCMDMAXFIXEDTYPEWIDTH. It limits the number of characters that...

Your current sql server log will show an informational message about which port it is using.

Message is about 20 entries from the beginning of the file.

Server is listening on [...

There is an implicit transaction for every delete/insert/update command. Therefore I have much better success doing the following:

set rowcount 10000;

-- do delete here;

set rowcount 0;

When trying to delete a...

I'll try to get the thread back on track and answer your actual question...

My experience is a proc gets written once and then goes through dozens of enhancements for the...

This thread has been on my mind the last few days. It focuses on communication hurdles and getting one's own way. I'd like to reframe the situation. ...