CONCAT( edit.ruleid, qr.description , 'Edit Code' )

You know about the perils of the (NOLOCK) hint, right?

May I ask why you are converting Row_Number() to an INT everywhere?

MadAdmin (4/7/2016)

---

amitsingh308 (4/7/2016)

---

Create table Script is as under:

Create table OrdersDetails(OrderNo varchar(30),ItemNo Varchar(20),ItemName Varchar(50))

insert script is as under:

Insert into OrdersDetails (OrderNo,ItemNo,ItemName) Values('122314','1','sdfasfasd123')

Now I want to change sequence number for order...

SQL!$@w$0ME (4/7/2016)

---

Hello guys,

We are planning to enable CDC for one of our databases.

Can we restore a copy on a different server (WITH KEEP_CDC option) and run the initial/incremental load...

Unticking the 'Sensitive' check box does not reveal the password, in case you were wondering.

SQLTougherGuy (4/6/2016)

---

Hi Phil,

If you are using integrated security, what security issues concern you?

I guess my question should be... "What types of security issues will I have to concern myself with...

SQLTougherGuy (4/6/2016)

---

Hello all,

I am going to try and explain what I am looking to do here, so please bear with me :-).

I have several SSIS packages that run off of...

amitsingh308 (4/6/2016)

---

Hello Everyone,

I have a transactional table which contains following columns

OrderNo. ItemNo. ItemName

But there is an issue I need to rearrange the item number if order number...

Jeff Moden (4/6/2016)

---

Link? I'd just like...

IF OBJECT_ID('tempdb..#a','U') IS NOT NULL

DROP TABLE #a;

CREATE TABLE #a (col1 sysname);

INSERT #a

(

...

Check out the most recent 'I am proficient ...' comment. I nearly regurgitated my breakfast cereal.

I am assuming that your FTP is running over the Internet. Try running this[/url] test, from both servers. Should...

dallas13 (4/5/2016)

---

Hello,

So we have 1 server in east coast and other in TX rackspace.

We have around 2 GB zipped db backup sitting in TX.

I have FTP job running through SSIS...

sks_989 (4/5/2016)

---

Thanks everyone input i was able to do from creating function

CREATE FUNCTION SplitString

(

@Input NVARCHAR(MAX),

...

Jon.Morisi (4/5/2016)

---

So a Visual Studio 2015 license / full install is required to do SSIS package development in SQL 2014+

...correct?

The link for Microsoft SQL Server Data Tools - Business Intelligence...