DECLARE @DATE_VARIABLE DATETIME = GETUTCDATE();

SELECT *

FROM ( SELECT CAST(DATEADD(DAY, -[N], @DATE_VARIABLE) AS DATE)

FROM...

Sorry, I totally...

Pretty sure this falls outside of...

Sorry, I totally misread the problem.

DECLARE @sql NVARCHAR(MAX);

SELECT @sql = 'SELECT RBR, '

+ STUFF((SELECT ',' + CHAR(13)...

Ouch 😉

When you can make something run better, why...

Few ways to do it, I've always preferred the cross-tabs

SELECT [pvt].[Domain],

[pvt].[CaseName],

[pvt].[Stream],

...

Also, seems you've asked this question in two forums (T-SQL and General).

I know you're probably hoping that just results in you getting an answer faster, but instead it just fragments...

Hey there,

Do you mind having a quick look at this link (http://www.sqlservercentral.com/articles/Best+Practices/61537/)[/url]? It's all about how best to post a question on these forums.

As things...

See the 8k splitter[/url].

CREATE FUNCTION [dbo].[DelimitedSplit8K]

--===== Define I/O parameters

(@pString VARCHAR(8000), @pDelimiter CHAR(1))

--WARNING!!! DO NOT USE MAX DATA-TYPES HERE! IT WILL KILL...

I guess a trigger on insert that saves the data in an audit table is the temporary solution until it gets properly fixed.

Don't know what the issue is (I don't use the framework, installed it to test if I could reproduce), but if you change the sproc Private_CleanTestResult to: -

ALTER PROCEDURE [tSQLt].[Private_CleanTestResult]

AS

BEGIN

...

Sounds similar to a "catch-all" query. Have a read through this (http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/) blog post[/url]. There are many other posts on the topic.

Interesting. Spent an little bit of time knocking this up based on Lowell's script that was uploaded here --> http://www.sqlservercentral.com/scripts/SQL+Server+2005/67515/%5B/url%5D

SET NOCOUNT ON;

IF OBJECT_ID('tempdb..#indexes') IS NOT NULL

BEGIN

...

Edward-445599 (8/6/2015)

---

I have the following scenario, The contents of main file are like :

ServerCentral|||||forum|||||||||||||||is||||||the||best

so||||||be|||||on||||||||||||||||||||||||||||||||||||||||||||it

And i need the output in the following form:

ServerCentral=forum=is=the=best

so=be=on=it

The logic being that multiple and consecutive occurrences of...

Minnu (8/5/2015)

---

Hi Team,

Below code is working.

with base as (

select

*,

rn = row_number() over (partition by user_name order by access_time desc)

from dbo.library

)

delete from base...