+1

Our little team's working with DB2. If you think...

Looks to me like an error in the query:

SELECT

A."CCUST" AS "CUSTOMER_NO",

A."CNME" AS "CUSTOMER_NM",

B."CTDESC" AS "CUSTOMER_GROUP_NM",

C."SNAME" AS "CUSTOMER_CAT15_DESC",

D."TMDESC" AS "TERMS DESCRIPTION",

E.CCCODE AS ZCC_CODE

FROM

ERPLXF."RCM" A

JOIN ERPLXF."RCT" B on B."CTCOMP"=A."CCOMP" AND...

-- Cursor version

DECLARE @sql varchar(max),

@col_three int

DECLARE temp_con CURSOR FOR SELECT DISTINCT COL_THREE FROM #test_table ORDER...

;WITH SampleData AS (

SELECT * FROM (VALUES (1 ,0.11, 0),(2 ,0.45, 0.5),(3 ,0.85, 0.75)) d (id, A, B)

)

SELECT *, F = r3.A * ( 1 - r3.B * (...

Igor Micev (10/1/2014)

---

You can use this function

CREATE FUNCTION dbo.fnGetMonthDays(@myDate DATE) RETURNS INT

AS

BEGIN

DECLARE @isLeap INT = 0

IF (YEAR(@myDate) % 400 = 0 OR (YEAR(@myDate) % 4 = 0 AND YEAR(@myDate) %...

Mohit Dhiman (9/30/2014)

---

SELECT DATEADD(m,DATEDIFF(m,'19001231',GETDATE()),'19001231')

This will give you the month end date for the current month (which can be changed by replacing GETDATE() with whichever other month-date you want)..

And you...

taylor_benjamin (9/29/2014)

---

I have been demonstrating how to create high performance Pivot transformations of data using SQL or Linq. Those queries both use a Pivot Table to enhance the performance of...

The "data length" of a row is more complex than simply counting the data characters. Columns have a minimum length, and many of the columns in your table have a...

arrjay (9/29/2014)

---

Thanks but I can't change what is already there. I can update the field I have referenced but a structural change would take too long to get deployed...

Koen Verbeeck (9/29/2014)

---

NVARCHAR(MAX) values are not stored inside the table but in LOB pages. However, a 24-byte pointer is still stored in the regular pages.

What's the Point of Using VARCHAR(n)...

Here is your DB2 query reformatted somewhat for clarity. The two subqueries in the WHERE clause are most likely to hit performance due to the non-SARGable predicates. If DB2 has...

We're using OPENQUERY & linked server to run ad-hoc queries against a DB2 database. We discovered quite early on that DB2 (or possibly the driver) will balk at almost anything...

If you're looking for a simple and reliable means of obtaining the last date of the current month, try this:

SELECT DATEADD(DAY,-1,DATEADD(MONTH,1+DATEDIFF(MONTH,0,GETDATE()),0))

Like this?

IF OBJECT_ID('tempdb..#iscr','U') IS NOT NULL DROP TABLE ##iscr

SELECT * INTO #iscr FROM _Iscritto WHERE 0 = 1

IF @cod_fondo = '2100'

BEGIN

INSERT INTO #iscr (<<column list>>)

SELECT <<column list>> FROM _Iscritto...

Shouldn't you be setting FldNumeric23764 to different values here:

UPDATE C14 SET

[FldNumeric23764]= case

when tID = 1 and Q.n <= 100 then 2

when tID = 2 and Q.n <=...