Lynn Pettis (4/22/2013)

---

Sean Lange (4/22/2013)

---

Lynn Pettis (4/22/2013)

---

You can also use this as a test harness:

set nocount on;

--===== Create the timer and bit-bucket variables and start the timer.

DECLARE @BitBucket sysname; --<...

Lynn Pettis (4/22/2013)

---

You can also use this as a test harness:

set nocount on;

--===== Create the timer and bit-bucket variables and start the timer.

DECLARE @BitBucket sysname; --< change or add variables...

It does seem to beat the DelimitedSplit8K version almost every time.

SET NOCOUNT ON;

declare @parameter varchar(100)

select @parameter...

Geoff A (4/22/2013)

---

use a tally table.

SELECT TOP 11000

IDENTITY(INT,1,1) AS N

INTO #Tally

FROM Master.dbo.SysColumns sc1, ...

Lowell is spot on but I think the bigger issue here is that unless you hate your system DO NOT do something like this. It is well known that the...

The real problem you are facing is that your data is not normalized. You are storing multiple values in a single column. By far the best thing you could do...

Notice how people just keep taking random attempts at helping you. If you would take a few minutes and post ddl, sample data and desired output you would have a...

Greg Edwards-268690 (4/22/2013)

---

Brandie Tarvin (4/22/2013)

---

The problem is he doesn't know jewelry from boo. He'd be just as likely to get me something hideous as he would to luck out and...

mister.magoo (4/22/2013)

---

Sean Lange (4/22/2013)

---

mister.magoo (4/19/2013)

---

Sean Lange (4/19/2013)

---

I had to dig around a bit to find this one. One of our legacy tables replicated from the Main Frame has a table...

mister.magoo (4/19/2013)

---

Sean Lange (4/19/2013)

---

I had to dig around a bit to find this one. One of our legacy tables replicated from the Main Frame has a table that nobody really...

I had to dig around a bit to find this one. One of our legacy tables replicated from the Main Frame has a table that nobody really knows it is...

dspeterson (4/19/2013)

---

Looks like doing...

logicinside22 (4/19/2013)

---

Hi guys ...

Like to know how i can store select query result in variable and then load it to the other table in SSIS-2005.

i am using...

SqlServerNinja (4/19/2013)

---

Hi Sean !

Thank you once again for trying to help me out .

I actually figured out the solution to the problem.

I did not do a good job of...

Gail Shaw has a two part series on her blog that is excellent.

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/%5B/url%5D

http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/%5B/url%5D