patrickmcginnis59 10839 (12/22/2015)

---

Eirikur Eiriksson (12/21/2015)

---

The problem is that xp_cmdshell can only...

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Of course when scanning the whole table the difference may be rather minor. It's the prevention of seeks that...

Ed Wagner (12/22/2015)

---

Phil Parkin (12/22/2015)

---

Sean Lange (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

Silver Spoon really doesn't seem to care about learning anything. Just the answer, that's all he is interested in.

I really hope...

ScottPletcher (12/22/2015)

---

Eirikur Eiriksson (12/22/2015)

---

My bad in the post before on the conversion, sorry about that.

😎

My point is that incorrect typing and implicit conversions do cause problems, I've lost count of...

Piling on Chris's and Jeff's good points, no need to persist that number, easily done in a query.

😎

Some sample data

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.tblVisit') IS NOT NULL DROP TABLE dbo.tblVisit;

CREATE...

Jeff Moden (12/20/2015)

---

Interestingly enough, I think that anyone passing 100K parameters to a stored procedure is 1) doing something wrong or 2) doing something really wrong. 😀 There...

Bhushan Kulkarni (12/21/2015)

---

Hi,

In our project, we have requirement such that user can set user defined properties for Entities- these properties will be dynamic.

So we implemented it using EAV model.

Base table...

My bad in the post before on the conversion, sorry about that.

😎

My point is that incorrect typing and implicit conversions do cause problems, I've lost count of how many of...

This...

Looks like MySQL/MariaDb, the CURDATE() and DATEDIFF with two parameters fits there.

😎

Home sweet home...gone!

😎

Or wrong server on a different domain:-P

😎

The problem is that xp_cmdshell can only take one double quoted...

Talib123 (12/21/2015)

---

This query has issues due to the \.

If I use a Where = it works fine. How do I get around this small annoying issue.

SELECT name FROM sys.syslogins

WHERE name...

jayaprabhalnt (12/21/2015)

---

Yes, I have the sysadmin permission.

I had also tried using the below command. But is is giving the same error.

exec master..xp_cmdshell '"\\RemoteServername\D$\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\dtexec.exe" / f"\\RemoteServername\C$\\Package3.dtsx"';

I guess...