SELECT CONVERT(TIME,CONVERT(SMALLDATETIME, @StartTime2))

mrpolecat (9/25/2016)

---

The incentive periods are 3 calendar months if there are no suspensions not including the end date in your example.

If an agreement starts on 1/1/2016 then the baseline incentive...

Matt Miller (#4)

Don't forget to incorporate the "sliding window" into your production version of this. In other words - if you're trying to capture all "readmits" in August you'd...

chef423 (10/4/2016)

---

I know this is a beginner type question but I am stumped.

I am attempting to convert a table called 'Inactive' which is a Boolean table. Its referenced from a...

valeryk2000 (10/3/2016)

---

The difference between yours and J's is that his singled out only first 2 records while yours - any number of records. The original dataset is selected on n>1...

Thanks for the...

Actually, our codes return quite different results.

Probably not on the set you're looking at, but nevertheless.

Here...

Oh, gosh, so much SQL...

So complicated code is not needed at all, if we think about the task.

We need to find which admissions have following up re-admissions of the same...

milindthakkar (9/22/2016)

---

Hi Gurus,

We have bit of weird issue at hand. Assume, we have two tables A and B and I am trying to insert values from B to A. And...

Can you explain how do...

Deadlocks do not happen when a single record gets updated.

There...

ghughes (9/23/2016)

---

Sergiy you are right again! The data changes, but not so much that I cant run a process every night/week and create a table of distinct full descriptions,...

Basically, yes.

The only difference appears when you have a value...

Smendle (9/23/2016)

---

I bolded and italicized the key word in the OP question

Maybe the correct answer is "You cant",...

You need to read CAST and CONVERT on MSDN:

https://msdn.microsoft.com/en-NZ/library/ms187928.aspx