adonetok (8/22/2014)

---

Thank yo for help.

If I put script like below, does it include all records?

SELECT

*

FROM @test-2 T

WHERE T.TEST_STRING in ('red', 'green') or T.TEST_STRING = ''

OR T.TEST_STRING...

Quick thought, two options, the developer should change the security setting to "Do not save sensitive..." or the second option, open the package in a text editor and remove the...

Quick thought, since you are (I think) on SQL 2012, why not use Extended Events?

😎

Quick thought, could this be caused by Cartesian Product, see the example?

😎

USE tempdb;

GO

DECLARE @TBL01 TABLE

(

T_ID INT NOT NULL

);

DECLARE @TBL02 TABLE

(

T_ID INT NOT...

Something like this? (code from another reply adopted to...

If I remember correctly, there is a backward compatibility components option in the SQL install, seen this problem when trying to access earlier versions of SQL Server without having the...

Quick thought, are the SSMS versions 2008 or later and could the backward compatibility be missing?

😎

Quick thought, use the LIKE operator

😎

USE tempdb;

GO

DECLARE @test-2 TABLE

(

TEST_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED

,TEST_STRING VARCHAR(50) ...

Quick question, are you using tabular SSAS/dax?

😎

bhavik.bk (8/21/2014)

---

G'day

was reading Distinct function on technet. There is a bit about VALUES FUNCTION. Anyone has idea how to use it? I tried using like distinct for a column,but...

Quick though, first move towards an SQL set based solution is to change the word Loop to Group. Each Group starts with Coke/Fanta and ends in a HardDrink:doze:

😎

Here is an...

After the second coffee I realised that the solution was in fact "current row and X following", here is a "X preceding and current row" improvement.

😎

use master

go

set nocount on

go

/**********************

** BUILD...

Here is a little "first coffee in the morning" solution:doze:

It uses two instances of a Tally CTE to generate a set N{N+0,,,,N+x} for framing the x rows preceding and current...

Edit: Oops, thought I was replying to this thread :w00t:

You are spot on, now I can reply which I could not do before your second post.:-)

😎

Here is a quick suggestion, should result in more consistent plan (for better or worse)

😎

CREATE PROCEDURE [Quotation].[Get_Quotes_LH] ( @From DateTime = null, @To DateTime = null )

AS

BEGIN

...