PJ_SQL (11/21/2016)

---

Hello,

I am sending data(text file) to third party which they import to their tool which users pull information from and make changes.

That data sent is combination of multiple...

mcfarlandparkway (11/21/2016)

---

I have an Execute Sql Task where I am using this SP.

CREATE PROCEDURE [dbo].[InsData]

@DB VARCHAR(20),

@FeT VARCHAR(20),

@SType VARCHAR(50),

@Id INT OUTPUT

AS

BEGIN

SET NOCOUNT ON

INSERT INTO dbo.Emp(FeT,DB,SType,StrtDate)

VALUES(@FeT, @DB, @SType, getdate())

SELECT @Id =...

What client...

djj (11/21/2016)

---

WayneS (11/21/2016)

---

Hugo Kornelis (11/17/2016)

---

Luis Cazares (11/17/2016)

---

Hugo Kornelis (11/17/2016)

---

Eirikur Eiriksson (11/17/2016)

---

Brandie Tarvin (11/17/2016)

---

Beatrix Kiddo (11/17/2016)

---

It's in the link there.

CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR...

Nagaram (11/21/2016)

---

when I run installation as upgrade getting below errors , However I am a admin user.

"TITLE: SQL Server Setup failure.

------------------------------

SQL Server Setup has encountered the following error:

Access to the...

zoggling (11/21/2016)

---

John Rowan (11/21/2016)

---

Consider changing your design. I prefer to not persist this type of value in my data. A view would be a great way to expose...

Jerid421 (11/21/2016)

---

I am mirroring about (23) tables in another DW. I have built my first incremental loads package, for the first table, and it successfully checks for new rows,...

Brandie Tarvin (11/21/2016)

---

Ed Wagner (11/21/2016)

---

Phil Parkin (11/21/2016)

---

Ed Wagner (11/21/2016)

---

Phil Parkin (11/21/2016)

---

Ed Wagner (11/21/2016)

---

Jeff Moden (11/21/2016)

---

I have to do some more research on it but it may be time for me...

It should be simple enough. In overview

1) Get software for the edition of SQL Server you wish to install...

Ed Wagner (11/21/2016)

---

Phil Parkin (11/21/2016)

---

Ed Wagner (11/21/2016)

---

Jeff Moden (11/21/2016)

---

I have to do some more research on it but it may be time for me to get ready to retire.

[font="Arial Black"]Microsoft...

Ed Wagner (11/21/2016)

---

Jeff Moden (11/21/2016)

---

I have to do some more research on it but it may be time for me to get ready to retire.

[font="Arial Black"]Microsoft Replaces Command Prompt with...

zoggling (11/21/2016)

---

Will an index not just potentially slow things down further?

Can you see any way in which this trigger can be improved? This seems to be our sole (and frequent)...

Here is the forum etiquette link: http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Notice how striking a resemblance your test data bears to that shown in the 'The Wrong Way to Post Data' section.

If you want a...

Nagaram (11/21/2016)

---

Hello Experts,

When I SSIS package from SQL Server Agent, getting error as below

"Description: Integration Services evaluation period has expired. End Error Error: 2016-11-21 16:00:00.96...

You've been here long enough to know what is required: sample DDL, INSERT statements containing sample data and desired results based on your sample data, please.