camiloecheverry11 (10/19/2016)

---

Hi linn,

thank you all for your help.

This is the situation in qty_on_hand does not appear the quantity that are in 0. What I need is to show all quantitys...

deekadelic (10/19/2016)

---

As it happens, I just got the restore this morning; so even if it wasn't the most efficient, server-load-friendly solution, it did do the trick.

However, I am going to...

camiloecheverry11 (10/19/2016)

---

I have a table a,b,c

and I need to show a if is >=0 and b >0 and c > 0

I know that this is simple but for some...

AT-2016 (10/19/2016)

---

I just want to return number of rows depending upon the value of Qty and order by last inserted rows in table2. In Table1, Paul has Qty 2, so...

AT-2016 (10/19/2016)

---

As Paul has Qty 2, so the query should return 2 rows from table 2 for Paul. Besides, it should return 1 row for John as he has Qty...

AT-2016 (10/19/2016)

---

Suppose, I've two tables as follows:

create table #table1(name varchar(100), qty int)

create table #table2 (forename varchar(100), surname varchar(100), cost int)

insert into #table1 values

('John',1),

('Paul',2),

('Ringo',1)

insert into #table2 values

('John' ...

The picture really doesn't help, we need the actual deadlock graph in its XML format.

Need a crystal ball or a contractor.

Eirikur Eiriksson (10/18/2016)

---

ZZartin (10/18/2016)

---

Damn I was...

philand3 (10/17/2016)

---

First Issue is:

my table dbo.test does not have any control on clock event(Clockin or Clocout) and table will accept whatever our Bio Metric machines throws the data. please note...

This is a cross post of this post: http://www.sqlservercentral.com/Forums/Topic1826702-3412-1.aspx.

Looks to...

Ray K (10/17/2016)

---

I just read someone the riot act for cross-posting.

I will admit that I only took a quick glance at the solution. Is he asking two different questions...

Robert vd Berg (10/17/2016)

---

@jeff: yes, the TR and CDC were in place several weeks before we've been having this problem.

@kevin:

1) What is the exact script you used to identify changed...

Can I quit now? Just Kidding, but definitely a bad last few weeks.