On the contrary, it is very useful as it respects the left outer join, which in essence return all records from the right hand side and only those on the...

Think of it this way, the AND will satisfy all records on the right hand side and return NULL on the left hand side for those records not satisfying the...

Quick suggestion, change this to a merge statement, look into the merge match conditionals "when matched" straight forward to handle this that way.

😎

Of course the more information provided the better the answer/advice;-)

The tables can of course be created beforehand, the solution posted is one of many ways of doing this. Tell...

Quick thought, conditioning a left outer join query on a column on the left side of the join effectively turns the join into an inner join, when the same predicates...

Good input @Seong-Bae Hwang, your approach is much more efficient as it bypasses the expensive XML table value functions and the string manipulation. Well done!

Must admit that I got a...

The task of populating a table from a stored procedure is simple, isolating the data for each client which makes this slightly more complicated as preferably each client should have...

Google doesn't like nnnnn..nnnnnn, try searching any set of numbers and the G guy will tell you he's sorry. Probably an effort to stop certain type of searches like ip...

The slowness of this website has gotten a lot worse for the past few days, hardly workable as it is. I'm not going to speculate on the causes but the...

Quick note, SQL Server does correctly encode all characters that need encoding, consider this example

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_SIZE INT = 15;

;WITH T(N) AS (SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL)) AS...

Here is a quick and simple window function solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH BASE_DATA(Heat_Index,HeatNo,Frame,Window) AS

(SELECT * FROM

(VALUES

...

Quick window function solution, should be self explanatory

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('dbo.qamt') IS NOT NULL DROP TABLE dbo.qamt;

CREATE TABLE qamt(id INT, amt INT);

IF OBJECT_ID('dbo.qtot') IS NOT NULL DROP TABLE dbo.qtot;

CREATE...

Linked server should be fine, even an SSIS packet on a schedule would probably do fine, all depends on the frequency required, transactional replication is probably an overkill in...

Think you better check out this

http://msdn.microsoft.com/en-us/library/dd207003.aspx

😎

What do you see in the Windows Event Log?

😎