Ken@Work (7/8/2010)

---

You did this on your phone?

That's great! Thanks,

However you are right.

The main reason I was going with a loop is because I could not get the bulk insert...

Ken@Work (7/8/2010)

---

I like the idea of Unions and have used them before, though I've never used them in inserts.

I'll be testing these shortly; it really looks like a good idea...

Don't know why he doesn't understand. . . SQL is by...

Very interesting.

3750

3.336

Microsoft SQL Server 2005 - 9.00.4028.00 (Intel X86)

Oct 20 2008 19:45:04

Copyright (c) 1988-2005 Microsoft Corporation

Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

Big load going...

Try this blog[/url]

You other brothers might deny

Does duplicate mean they have to be next to eachother in the source?

Hmmm.

Is this what you're after?

--Test Data

DECLARE @table AS TABLE(

TIME DATETIME)

INSERT INTO @table

...

DECLARE @weekDay TABLE (

mask INT

, maskValue VARCHAR(32)

);

INSERT INTO @weekDay

SELECT 1, 'Sunday' UNION All

SELECT...

Mr_Bacon (7/6/2010)

---

Still no luck with this, I will try to simplify in another example.

I want to get the current datetime (where DATEDIFF(minute,time, getdate()) ), then minus 240 minutes...

Hey there. I can't quite understand what you want here. So, check this out

DECLARE @table AS TABLE(

TIME DATETIME)

INSERT INTO @table

SELECT...

On 2005

DECLARE @test-2 AS VARBINARY(MAX)

SET @test-2 = 0x4858FE25053CA4D236F3D61AE29668BA

SELECT @test-2 AS [VARBINARY]

,MASTER.dbo.Fn_varbintohexstr(@test) AS [VARBINARY SP]

,@@VERSION AS [SQL Version]

/*

VARBINARY ...

Theo-929802 (7/5/2010)

---

Just said to the user that creates the file to save it as .csv through excel. There is no mess with file names and sheet names.

It really made my...

arun8006 (7/4/2010)

---

Hello Gurus,

I have created a package with parameters, the package takes DB name1 and DB name2 and copies DBName1.TblA to DBName2.TableA, And these names are parameters, I have given...

Excel is a pain to deal with in SSIS. You can get so many stupid meaningless errors that it isn't worth doing if there is any way around it.

For example,...