Your...

SQLPain (12/29/2015)

---

Trying to match a.dateappreceived with todays date, code 1 works, 2 and 3 do not, cant figure out th reason:

WHERE (a.DateAppReceived Between GETDATE()-1 AND GETDATE())

WHERE (a.DateAppReceived = CONVERT(varchar(10),(DATEADD(dd, datediff(dd,...

What is the data type of a.DateAppReceived?

mr.databases (12/14/2015)

---

Hi Group!

CASE WHEN det_dte IS NULL THEN CAST({ fn NOW() } - rec_dte AS int) ELSE CAST(det_dte - rec_dte AS int) END

rec_dte and det_dte are both data type datetime.

The...

This is query is similar to what you have except that it has 1 less table scan because there is 1 less inner join, which made it about 45ish% faster....

You can try changing the column to an identity column under Design in SMS. If that works, you may have to seed the table with the correct next identity...

This should do it:

with cte as

(

Select hierarchyid, hierarchyval,

row_number() over(Partition by hierarchyval order by hierarchyid) RowNum

from #test

)

select *...

Glad it worked for you.

Just for the fun, here is a version that will work...

Since you posted in a 2014 forum, here is a solution that will work in any version after 2012.

Please read the link in my signature line and note how the...

😎

jkramprakash (9/24/2015)

---

. . . first three records the columns id and no contains same value.

i want to delete this three records.

but in last record for id =35 and...

Paul Munter (9/22/2015)

---

We need to extract only the sessions that are the equal to the length defined on the master schedule table. In this case we have sessions which are...

Is this what you are looking for?

declare...

hegdesuchi (9/16/2015)

---

also,

another scenario is,

Scenario:

ODS table :

CustomerID column1column2column3

1abcabcabc

2xyz xyz xyz

Dbo table:

CustomerID column1column2column3 date

1abcabcabc 1/1/1900

2xyz xyz xyz 1/1/1900

Now If I get any new record for customerID "1" in ODS table,...