Like this:

[font="Courier New"]INSERT INTO dbo.tblClients

   (Client_Short_Name,

   Client_Long_Name,

   CountryCode,

   ClientID)

SELECT

   CASE WHEN LEN(c.Client) > 30 THEN LEFT(c.Client, 27) + '...' ELSE c.Client END AS Client,

   CASE WHEN LEN(c.Client) >...

Hi Johann

Looking at this from a slightly different angle...which variables do you have populated before you run this bit of code (nicked from Gail's post, thanks Gail)...

SELECT @BuildID = BuildID

FROM...

Hi

You could truncate using LEFT() as follows:

[font="Courier New"]DROP TABLE #tblClients

CREATE TABLE #tblClients (

Client_short_Name NVARCHAR(30) NOT NULL,

Client_long_name NVARCHAR(100) NULL,

CountryCode VARCHAR(5) NULL,

ClientID NVARCHAR(10) NOT NULL)

DECLARE @Client VARCHAR(255)

SET @Client = 'This is...

pri.amin (11/28/2008)

---

Ok cant seem to get around this,

the error is:

Msg 8152, Level 16, State 4, Procedure procImportAllFiles, Line 33

String or binary data would be truncated.

The statement has been terminated.

dbo.tblClients

Client_short_Name...

rbarryyoung (11/27/2008)

---

Chris:

I just notice that you are putting "and" after your Hundreds, like this:

Technically, this is...

Testing in my reporting environment yields...

Jeff Moden (11/27/2008)

---

Chris Morris (11/27/2008)

---

Here's a 2k/2k5-friendly version with a permanent lookup table. It translates 30,000 numbers from a standard tally table, in both SQL Server versions, in about 4...

Here's a 2k/2k5-friendly version with a permanent lookup table. It translates 30,000 numbers from a standard tally table, in both SQL Server versions, in about 4 seconds.

[font="Courier New"]IF EXISTS...

Hello

A quick Google confirms that this requirement is fairly common nowadays. The following thread describes a couple of sprocs which could be used to help, with a minimum of fuss.

http://www.tek-tips.com/viewthread.cfm?qid=1499975&page=11

This...

Hi Thatok

If you are intending to eliminate from your result using the condition

If the fifth character = 0 then the sixth character should not be 0.

then shouldn't this do the...

Thanks Jeff, it's...

You're spot on. It works fine in 2k, I should have tested it in 2k5 :blush:. The...

Matt Miller (11/26/2008)

---

Chris Morris (11/26/2008)

---

UNION ALL shouldn't be necessary because none of the rows are duped.

I'll test it for speed tomorrow using a permanent table. A whole minute for...

TheSQLGuru (11/26/2008)

---

That looks pretty slick! A minor nitpick would be to use UNION ALL for populating the table variable. Also, if this were to be used regularly I...

Hi Nishant

It's exactly as your error message states, you can't use

INSERT INTO NewDataBase.Extensions.FieldSelectionGroups

SELECT *

FROM OldDataBase.Extensions.FieldSelectionGroups

you have to use

INSERT INTO NewDataBase.Extensions.FieldSelectionGroups (column1, column2 etc)

SELECT column1, column2 etc

FROM OldDataBase.Extensions.FieldSelectionGroups

Cheers

ChrisM