Jeff Moden (5/2/2015)

---

Heh... it wouldn't be "quick" though because it wouldn't be SARGable if the same formula the OP used were...

KGJ-Dev (5/1/2015)

---

Hey Guys,

thanks for your reply.

I Eirik,

before i though of posting on this forum, i thought about using Jeff's delimit function what you have suggested. But i am sorry that...

polkadot (5/1/2015)

---

Does anyone know the fix?

Have read this article and tried suggestions: http://stackoverflow.com/questions/10888616/why-is-ssis-complaining-that-there-is-a-partial-row-at-the-end-of-the-file

have read this KB article stating it is a known bug with a SP fix for 2005...

Quick example

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

/* SMALLINT MAX = 65535 */

DECLARE @SAMPLE_SIZE INT = 65535;

;WITH T(N) AS (SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL)) AS X(N))

, NUMS(N)...

Train

Quick suggestion, generate the sequential bits separately and use the stuff function to merge it into the guid.

😎

Quick thought, schema qualify the table name by adding the schema name + dot prefix.

😎

Quick suggestion, use the GETDATE() function in T-SQL

😎

For fun, yet another solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('dbo.TBL_SAMPLE_PARSE') IS NOT NULL

DROP TABLE dbo.TBL_SAMPLE_PARSE

CREATE TABLE dbo.TBL_SAMPLE_PARSE

(

SP_ID INT IDENTITY(1,1) NOT NULL ...

Quick solution, should be self explanatory (I'll add comments if I'll get the time;-))

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.Test_ROADS

(

Hwy...

Jeff Moden (5/1/2015)

---

It's clever but I have to disagree with that being a good example of a "Read Only Try/Catch" because it returns two result sets instead of just one....

Skyr

Jeff Moden (5/1/2015)

---

I had a rare and wonderful opportunity, today. Luis is in town and I finally got to meet him and have lunch with both him and Ed...

Eric M Russell (5/1/2015)

---

Eirikur Eiriksson (5/1/2015)

---

Eric M Russell (5/1/2015)

---

Eirikur Eiriksson (5/1/2015)

---

Eric M Russell (5/1/2015)

---

Static code analysis doesn't know how many times the code is executed, how much data it accesses,...

diogo_1984 (5/1/2015)

---

I wish my transform variable, so that adding the OR operator, and the words within the quotes are not to put the OR.

ALTER PROCEDURE

@product = ' 'ORANGE LEMON'...