The long forgotten PATH command from MS-DOS days is very much alive still in Windows, just not as accessible. I bet that the path for the 100 is before the...

Just curious, but are these new...

Chris Harshman (1/5/2017)

---

I'm taking a guess here, not sure if I completely understand the question, but if you just want for one specific FeeTable:

SELECT TOP 1 OffSet, Amount

FROM...

SQLserver_learner (12/30/2016)

---

i tried below query .. this is not working .. Could you suggest correct change? Thanks

WITH LatestDates AS (

SELECT

[MDDS01_MDD_STORE_GU_D]

,[MDDS01_CATALOG_D]

,[MDDS01_LAST_UPDT_S]

,ROW_NUMBER() OVER (PARTITION BY [MDDS01_CATALOG_D] ORDER BY [MDDS01_LAST_UPDT_S] DESC) AS...

jason.shaw (12/28/2016)

---

SELECT *

FROM <TABLENAME>

WHERE ACCOUNT_NUMBER IN ('100', '150', '175')

and once those acct numbers are selected per query above, I need to change an field value for each...

Just curious, but which solution worked for you?

Can you try:

Where Coalesce(A.Department,...

tacy.highland (12/2/2016)

---

Hello all,

We have time saved in our db in a seconds after midnight format and need to convert it to a regular AM/PM time format. Currently we use...

I have edited my earlier post to include create and insert statements for table2.

I must be dense, but your explanation and your example output do not make sense to me....

knight944 (11/18/2016)

---

unfourtunatly i am unable to post this information... but hope this helps...

table1

(

ID CHAR(10)

SUB_ID CHAR(3)

DESC CHAR(100)

)

table2

(

ID CHAR(10)

DESC CHAR(100)

)

I would need to look through table 1 so that for every...

Please read the article contained in the link in the signature line. It will show you how to post DDL and data so that we are not guessing as to...

Merge

or

Insert Table1 (columns)

select columns

from table2

where not exists (select 1 from etc. . .)

sharonmtowler (11/18/2016)

---

Hello,

I have a query I am using in an ssrs report. It works great when run on the sql server. Once I put it in SSRS I get...

GilaMonster (11/8/2016)

---

I would recommend, instead of creating one trigger FOR INSERT, UPDATE, DELETE, you create three different triggers. One FOR INSERT (which will be fired only for the inserted rows...