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?

😎

Quick runnable demonstration on the flexibility of FOR XML PATH

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH BASE_DATA(BD_ID,BD_VAL) AS

(SELECT * FROM (VALUES

(1,'ABC')

...

Quick thought, in command prompt run "net start", the sql server instance will show up in the output if running, if not, start the instance.

😎

I...

Quick suggestion, create a view with compliant names, i.e. replace spaces with underscores, then specify the proper field name in the report. There is a three year old Connect entry...

jonen (10/3/2014)

---

Hi. I've just started a new job and working with Access databases, but these are getting very close to the 2gb size limits. My predecessor simply created a new...

Quick suggestion, try two separate queries, one for each email table and combine the results using union all.

😎

You are very welcome. Out of curiosity, what do you use for splitting the incoming parameters?

😎

Quick suggestions since Id's can be shared by Categories

😎

USE tempdb;

GO

DECLARE @t TABLE (Id INT)

INSERT INTO @t

SELECT 108 UNION ALL

SELECT 102 UNION ALL

SELECT 103 UNION ALL

SELECT 101;

DECLARE @t2 TABLE (CategoryId INT,...