Javier-157657 (7/5/2012)

---

Each 3 rows in original table go to one row in the new view.

E.g:

Row1,Row2 and Row3 from original table go to Column1, Column2 and Column3 in the first...

tush002sunny (7/5/2012)

---

Hi,

I have two packages & four stored procedures.

I am calling all these through a SQL server job. It may be possible that there is a change in requirement &...

Raghavender (7/5/2012)

---

rhythmk (7/5/2012)

---

Raghavender (7/5/2012)

---

We have different instances on those we have to run one SQL script, and the result to be stored in another instance.

This is the thing I am...

Ford Fairlane (7/5/2012)

---

Sample Data:

XXX XXXX:16 RHP PMC:11 Document Control:03 Documents for Review:03 Supplier Reviews:RHIO-005620 BGC:100RH-1000-CI-PRO-1001_A.pdf

XXX XXXX:16 RHP PMC:11 Document Control:03 Documents for Review:03 Supplier Reviews:RHIO-005620 BGC:100RH-1000-CI-PRO-1002_A.pdf

XXX XXXX:03 Commercial:02 Procurement:07 Purchase...

That...

christophe.bernard 47659 (7/5/2012)

---

Hello,

the reason that they don't like the test IF in a stored procedure is due to the performance, they tell me that condition AND OR is better than...

ssa2010 (7/5/2012)

---

What are the main difference between SQL 2005 and SQL 2008

Also mention the difference between SQL 2005 Express Edition and SQL 2008 Express Edition like their DB size limitation...

Raghavender (7/5/2012)

---

Otherwise please let me know how to do the below scenario using SSIS:

I have a query which need to be run on different instanceas and the result to be...

Ford Fairlane (7/5/2012)

---

I have a table as such

CREATE TABLE [dbo].[DAuditNew] (

[EventID] bigint IDENTITY(1, 1) NOT NULL,

[AuditID] int NOT NULL,

[AuditStr] nvarchar(32) NOT NULL,

[AuditDate] datetime NOT NULL,

[DataID] int NULL,

[SubType] int NULL,

[UserID] int...

Hi Sudhakar,

As Koen mentioned that Checkpoints can be configured for Control Flow tasks only not for...

I guess Kingston got the perfect...

raghavatgk (7/4/2012)

---

here is dml for the required tables.

create table #Genre(gid int, Genre_name varchar(100))

insert into #Genre values(521,'classical')

insert into #Genre values(523,'pop')

insert into #Genre values ( 627,'fusion')

Create table #music(gid int,mid varchar(10),Era varchar(20))

insert into...

prudhivi9 (7/4/2012)

---

Hi,

I jst followed the link wh u hav specified there,

but one thing is like how to create a batch file for all the packages, can i get any syntax...

prudhivi9 (7/4/2012)

---

Hi All,

Actually we are working with two servers,

my requirement is like this,

i want to copy packages from server A msdb to Server B msdb.

Am having many number of packages...

Steve wants us to see movie but with your comment i'll not...