whenriksen (12/21/2016)

---

Here you just scare people...

And now that I've seen the post about needing to deal with the possibility of more than one action in a given day, I've decided to tackle that one. ...

Okay folks, having realized that my query was only going to handle one ID value, I began to look a little deeper into this. I won't necessarily worry...

Just another way to tackle it, using CROSS APPLY:

IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'Data')

DROP TABLE Data;

CREATE TABLE...

drew.allen (12/20/2016)

---

Most approaches that I've seen collapse the ranges. That is, they don't retain a record with a zero length. Is there a particular reason that you need...

Brad Feaker-195979 (12/20/2016)

---

Maybe my skull is a little too thick today but I cannot figure out why this is not grouping correctly:

SELECT CAST(Coalesce (RIGHT(EDI_Batch_Number,4), 1325 ) AS VARCHAR(4)) AS 'Batch...

gp-sql-novi (12/19/2016)

---

Hi,

I have created a stored procedure(1) to do an insert / update when a parameter is passed. i have a table that stores name and age, and a...

Lord Slaagh (12/19/2016)

---

Hello SSC,

I have been struggling trying to import data from SQL to Vertica using CMD shell. Does anyone have experience with this? I would like to be able...

Replicant21 (12/20/2016)

---

Hello,

I'm looking for some advice on the best way to change the data type on a column from an INT to a BIGINT on a table with 220 million...

gdpollock (12/19/2016)

---

Hi Steve,

In my brevity, I think I left some details out. I don't believe this will be a case of users editing their reports--they'll input other data that...

Either that, or you've traveled 90 years into the past... 😉

gdpollock (12/19/2016)

---

All,

I'm starting a new position as a SQL developer for an organization that primarily does reporting. They are now getting requests to allow record-edits and simple insert update...

psred (12/19/2016)

---

I want to know how to Set BUFFERCOUNT, BLOCKSIZE, and MAXTRANSFERSIZE for BACKUP command for faster backup. I have a 700gb db trying to backup to a disk but...

rash3554 (12/19/2016)

---

Hi there,

I want to do FulltextSearch on only 500 characters of columns in a table to find employees and companies that use Natural Language processing (NLP)

Employee...

CELKO (12/18/2016)

---

Illiterate and ignorant? Which...