mario17 (9/10/2014)

---

Hi, all

That what we got, we had very nice tuned MView defined on Server01 against tables in dbA and dbB (on same Server01).

OK it's time to...

More for fun, here is a quick alternative solution

😎

USE tempdb;

GO

DECLARE @NOW DATE = GETDATE();

;WITH CV_WORKEXP(CVID,StartDate,EndDate) AS

(

SELECT CVID,StartDate,EndDate FROM

(VALUES

(28387 ,'2008-01-01','2012-09-01' )

...

Eugene Elutin (9/10/2014)

---

Eirikur Eiriksson (9/9/2014)

---

Alan.B (9/9/2014)

---

IF @user > '' --This checks for not null and not empty

Cool. I never knew you could do that, very interesting :laugh:

Edit: sql code tag...

TomThomson (9/10/2014)

---

Stefan Krzywicki (9/10/2014)

---

TomThomson (9/10/2014)

---

It's probably the...

GilaMonster (9/10/2014)

---

Well, months have no more than...

Alan.B (9/9/2014)

---

IF @user > '' --This checks for not null and not empty

Cool. I never knew you could do that, very interesting :laugh:

Edit: sql code tag messed up my "greater...

The code is missing the FROM clause in addition to few minor syntax errors, here is a quick correction

😎

Declare @Sem varchar (12) = Null

DECLARE @Decision varchar(1) =...

GilaMonster (9/9/2014)

---

In short, if you don't have explicit transactions (BEGIN TRANSACTION ...), there's no reason to have xact abort on. Xact abort defines whether an explicit or implicit transaction rolls...

Makes no difference in terms of SQL injection.

😎

Sure made me question but not necessarily did it urge me to write one:-P

😎

sgroesz (9/9/2014)

---

I've set up a report with two parameters, @StartDate and @EndDate. Report users expect to enter the following values:

StartDate: 9/20/2013 EndDate: 9/20/2013 -- Show all records dated...

Quick...

The procedure is either in an...

Quick note, cannot recommend a string manipulation of the XML, rather use the XMLNAMESPACES directive, here is a quick parsing demo, note that the datatype specification in the value functions...

Amu (9/8/2014)

---

I have an application which one of the query (within stored procedure) execution plan keeps changing. I am running rebuild index and update stats on regular basis on this...