Quick thought, sum the addition of all columns

😎

SELECT

SUM(TS.COL_001 + TS.COL_002 + TS.COL_003 + TS.COL_004 + TS.COL_005 + TS.COL_006 + TS.COL_007 + TS.COL_008 + TS.COL_009 +...

Quick thought, use trace flags 1117 and 1118

😎

Echoing Jeff´s question and adding some more, are you using a single file tempdb configuration? Do you know what is causing the growth? Are you experiencing any congestion in the...

Quick suggestion (pseudo code)

😎

DECLARE @ParamTable varchar(100) = N''; -- include schema, error...

KGJ-Dev (12/4/2014)

---

Hi Erik,

as i don't want to open a new post for this, as we have all the information on this post, i would like to extend this conversation.

I am...

No shredding, just minor improvement

😎

First a data set

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @DUMBER_OF_CLUBS INT = 200;

IF OBJECT_ID('dbo.TBL_CLUB') IS NOT...

Herpington_McDerpington (12/3/2014)

---

Eirikur Eiriksson (12/3/2014)

---

Quick questions, what is the data source (ORA Version)? Have you tried using ALTER SESSION SET NLS_DATE_FORMAT to "format" the output of CURRENT_DATE? Don't think it's...

Herpington_McDerpington (12/3/2014)

---

Hello all, I'm not really sure what level of expertise folks may have in the ODBC realm here. If there's a more appropriate category on the forum please let...

Steve Jones - SSC Editor (12/3/2014)

---

Don't knock LinkedIn too much. It's networking, which is incredibly valuable if you need employment or want to move. Many of you have used networking...

twin.devil (12/3/2014)

---

Koen Verbeeck (12/2/2014)

---

Eirikur Eiriksson (12/2/2014)

---

Just and only for fun, here is a slightly twisted solution, recommend following Koen's suggestion

😎

DECLARE @STR VARCHAR(100)='My name is Shiva';

DECLARE @XSTR VARCHAR(MAX) = 'SELECT(SELECT CHAR(32)+Y.XN...

Quick thought, use a calculated column for an "active" flag, here is an example, not a full solution but should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT...

Quick sample code, not a complete solution but should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('dbo.TBL_DETECT_DUPES') IS NOT NULL DROP TABLE dbo.TBL_DETECT_DUPES;

IF OBJECT_ID('dbo.SVFN_COUNT_DETECT_DUPES_CODE') IS NOT...

swoozie (12/2/2014)

---

I tried to do the following:

1) remove the references to the extra table from the XSD = didnt work

2) Change the name of the column in the XSD still...

Ed Wagner (12/2/2014)

---

Eirikur Eiriksson (12/2/2014)

---

Luis Cazares (12/2/2014)

---

Sean Lange (12/2/2014)

---

David Burrows (12/2/2014)

---

Luis Cazares (12/2/2014)

---

...it can be easier to start from scratch if we can understand the problem, than fix a complete...

Luis Cazares (12/2/2014)

---

Sean Lange (12/2/2014)

---

David Burrows (12/2/2014)

---

Luis Cazares (12/2/2014)

---

I have...