caffeinated (8/31/2014)

---

True, date conversions get tricky depending on context. But taking into account students, and school system, I'm guessing that level of accuracy isn't necessary.

Your example introduces division by...

Quick thought, no need to use recursion or loops, rather use the LAG window function. Here is a quick sample code with some test data.

😎

USE tempdb;

GO

DECLARE @TEST_DATA TABLE

(

...

Quick thought, the datediff function sometimes plays tricks on us, not to be trusted blindly, look at this sample

😎

USE tempdb;

GO

DECLARE @TEST_DATA TABLE

(

TD_ID INT...

Good job with the DDL and the sample data, will have a...

polkadot (8/31/2014)

---

Yes, and that's his point. That if a lot...

polkadot (8/31/2014)

---

Clarification of your answer please.

If there are 2 servers whose databases are linking to a 3rd server's database, do each of the 2 server's linked server names have to...

Thanks for sharing the information. One quick question, what is the isolation level set in the connection configuration?

😎

The default constraint will only work on inserts not updates. The code sample below demonstrates this.

😎

USE tempdb;

GO

CREATE TABLE dbo.TBL_TEST_CONSTRAINT

(

TC_ID INT IDENTITY(1,1) NOT NULL

...

As a quick fix, add a HOST entry for the server on the client...

Quick thought, look at sys.partitions and sys.tables

😎

If I remember correctly, Itzik Ben-Gan wrote an article on paging result set, both with and without offset fetch, suggest you look at it.

😎

Edit: added link.

karthik82.vk (8/31/2014)

---

Hi,

I have a data of 100 PostalCodes and parcels associated with it. Each postal code will be having multiple parcels. My aim is to find the count of parcels...

This is more for fun than being an attempt to solve the problem, although the code can easily be amended to produce the desired results. It uses an inline Tally...

Here is an alternative method without recursion, uses Tally table type looping instead. The code uses Chris's sample data to produce comparable output. It is simplified and limited to that...

TomThomson (8/30/2014)

---

Eirikur Eiriksson (8/30/2014)

---

sharonsql2013 (8/30/2014)

---

I am trying to do an average with the following case statement

Select

AVG(Case when TotalHours < = 60 And TotalHours > 0 then TotalHours else...