Lynn Pettis (4/3/2013)

---

erikd (4/3/2013)

---

There is no...

There is no space.

USE [blah]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROC [dbo].[DeDupe]

@projectID int,

@dupVar1 varchar(20) ='',

@dupVar2 varchar(20) ='',

@dupVar3 varchar(20) =''

as

DECLARE @ProcessTable varchar(64)

select @ProcessTable=ds_ProcessTable from...

Sean Lange (4/3/2013)

---

erikd (4/3/2013)

---

Sean Lange (4/3/2013)

---

Using your dynamic code as an example this will produce the same results but as a single query instead of 1 query for each column....

Sean Lange (4/3/2013)

---

Using your dynamic code as an example this will produce the same results but as a single query instead of 1 query for each column.

declare @thing nvarchar(max),...

ScottPletcher (4/2/2013)

---

It's a huge waste to do a separate SELECT from the table for each column.

You can do a MAX(LEN(column_name)) for all columns in one SELECT statement, and hopefully thus...

i run into truncation issues a lot. i've been using this to check the max length of raw table column values when they won't load to my processing table:

declare @thing...

heh. no. i had a monumental brainfart.

i was looking at the 'diff' column like it was a count, not like it was showing the difference between the two dates.

sorry...

bitbucket-25253 (2/20/2013)

---

You may want to look at the procedure (in the Master DB) titled

[sys].[sp_MSforeachtable].

Review the T-SQL to determine if it will perform as you want it to, or if it...