Lutz, I'm just giving you a chance to show a better approach. 😀

Seriously, I prefer...

Duncan Pryde (6/28/2010)

---

Changing the subject somewhat...

Although I knew that you can have negative seeds and increments for the IDENTITY property, I've never actually used them myself.

I'd therefore be interested to...

My systems were...

Lynn, you asked specifically about BIDS, but I thought I'd talk a little bit about issues with SSMS.

If you have both 2005 and 2008 servers, do NOT use SSMS 2008...

And a way that would get rid of parameter sniffing would be:

CREATE PROC MainAll

AS

SELECT S.SALESPERSON,

...

I'm agreeing with Gail... the MS "IntelliSense" in SSMS 2008 gets in my way so much that I've disabled it. It would be really nice if MS would just license...

Do all of your inserts first, then finally select from the output table. (instead of insert 1, select 1)

That error is an SSMS (GUI) message - it only displays results...

Use the OUTPUT clause:

declare @MusicArtists TABLE (RowID INT IDENTITY, FirstName varchar(30), LastName varchar(30), Instrument varchar(30));

declare @MusicArtistsAudit TABLE (RowID INT, FirstName varchar(30), LastName varchar(30), Instrument varchar(30));

INSERT INTO @MusicArtists (FirstName, LastName, Instrument)

OUTPUT...

Might I suggest:

declare @Country varchar(50)

set @Country = CASE @Parameter WHEN 1 THEN '%'

...

I just recently had to load data in from a flat file, and had to ensure the order (well, I actually had to be able to get the first row...

How's this?

declare @test-2 table (OrderNumber smallint, OrderDate datetime)

-- See how you start off by actually creating a table

-- and then inserting the data into it? Doing this really

-- makes...

First, you need a delimited split function:

IF OBJECT_ID('dbo.DelimitedSplit') IS NOT NULL DROP FUNCTION dbo.DelimitedSplit

GO

CREATE FUNCTION [dbo].[DelimitedSplit] (

@list varchar(max),

@Delimiter char(1)

)

RETURNS TABLE

AS

RETURN

-- first, need to break down into...

Can you get the delimiter changed?

If you don't have any control over the file, then you need to be screaming really loud to who does about how they should not...

To my knowledge, no.

Paul, have you got any guidelines as to when you should and should not compile a UDF WITH SCHEMABINDING?