Bill Talada (1/29/2015)

---

Interesting problem. I see you want to consume inventory in expiration date order.

Personally I would do this procedurally in a loop in a stored procedure, filling a...

136romy (1/29/2015)

---

hello SSChampion

thank you for answered

As done in my previous request I would like to apply the FEFO system so if I have for example the following product data:

Numlot 1...

Steve Jones - SSC Editor (1/29/2015)

---

Eric M Russell (1/27/2015)

---

Regardless of datatype, I don't want to see a column names having no contextual prefix, meaning just "ID" by itself, on any...

I haven't a clue. I am old(ish) but not senior. I am not even a junior dba. I have been at my current job for 6 1/2 years and have...

Your script has some foreign keys in the wrong order but I was able to work that out. What we don't have is any sample data or any kind of...

lsalih (1/28/2015)

---

I have 2 tables:

tbl1: InstituteID, name

tbl2 ApplicantID, InstituteID ,Applicant_Name, address, city, state, status *

* Status field contains value A for acceptance or R for rejected

I need help with listing...

Did you even try? https://www.google.com/search?q=What+are+the+basic+queries+to+trouble+shoot+the+always+on+in+sql+2012+%3F&ie=utf-8&oe=utf-8

Your exact question returns several good locations.

That is NOT multiple values. It is a single string value that contains some characters and some...

What pietlinden is saying is that you didn't provide any details. Please see the first link in my signature for best practices when posting questions.

jbalbo (1/27/2015)

---

Thanks for the info, definitely helps...

I was also wondering if I was using the view Gui interface where I can pick tables or other views if I can point...

Sounds like an interview question to me. 😉

In addition to Eirikur's response when you declare variables with datatypes that have a size you should ALWAYS define the size. Defining varchar with no size will get the default...

Luis Cazares (1/27/2015)

---

MMartin1 (1/27/2015)

---

Luis Cazares (1/27/2015)

---

If it's a string column with underscores between each part of the date. This could be an option.

SELECT columns_to_return

FROM dbo.XYZ

WHERE date_column...

Luis Cazares (1/27/2015)

---

Carlo Romagnano (1/27/2015)

---

Raghavendra Mudugal (1/27/2015)

---

actually I was doing...

d.krishnap (1/27/2015)

---

Thanks for the reply

Question

You cannot vote on your own post

0

if there 3 records in bill_detail table like this

INSERT INTO DETAIL

([objid], [x_billable_to], [x_bill_quantity], [x_billable_yn], [x_bill_rate],[COST_TYPE])

VALUES

(1, 'Customer', 3, 1, 20,'Parking'),

(2,...