DamianC (11/29/2016)

---

Ed Wagner (11/29/2016)

---

djj (11/29/2016)

---

Manic Star (11/29/2016)

---

Ed Wagner (11/28/2016)

---

Manic Star (11/28/2016)

---

DamianC (11/28/2016)

---

Ed Wagner (11/28/2016)

---

Manic Star (11/28/2016)

---

Ed Wagner (11/28/2016)

---

djj (11/28/2016)

---

Ed Wagner (11/26/2016)

---

DamianC (11/26/2016)

---

Ed Wagner (11/26/2016)

---

TomThomson (11/24/2016)

---

Brandie Tarvin (11/23/2016)

---

Manic Star (11/23/2016)

---

Luis Cazares...

vs.satheesh (11/29/2016)

---

Hi , I am using sqlserver 2005, UIn my scenario I need apply gracing marks for following scenario.

drop table #temptable

create table #temptable (USN varchar(15),Scode varchar(10),Theory_Mark int,Practical_mark...

You could certainly format the code yourself or use a tool like poorsql.com

On the other hand, we need DDL and sample data in a consumable format. Read the links in...

info 58414 (11/23/2016)

---

Hi,

i have a Select with this Result;

ID RowCount

FKR000000000001 34

FKR000000000002 21

FKR000000000003 28

Can i write a recursive Cte, which generates as many records as the RowCount indicates.

For...

Steve Jones - SSC Editor (11/23/2016)

---

robert.sterbal 56890 (11/23/2016)

---

What is on your menu for Thanksgiving?

Can you share any recipes?

Our family will be having Thanksgiving at my wife's parents with turkey, gravy,...

Hopefully, some football :hehe:

Apple

What if someone creates a stored procedure that elevates their privileges? Are you protected from that?

Warcraft

You just need to invert the logic.

DECLARE

@StartDate DATE

,@EndDate DATE;

set @StartDate = DATEADD( day,-30, getdate());

set @EndDate = GETDATE();

SELECT *

FROM(

SELECT...

Science

The good part is that you're moving forward. 😉

There's no significant...

I'll guess that you have a proxy account set to use xp_cmdshell. I'm also guessing that you're not using a sysadmin account to run xp_cmdshell. Then, I'll guess that the...

draca.milos89 (11/21/2016)

---

Hello, I have text files that are tab delimited. My Bulk works fine until I discovered one situation if I value in the last row column filed is empty...