mithubhudolia (1/27/2012)

---

Hi All,

I have to show data in reports (day wise and moth wise)

Like

In jan month ,we have 31 days so if data is available in 1'jan than show data...

Ulysses_Infinity (1/13/2012)

---

This is a fairly poor Featured Script. Isn't the point to shed some light on the methodology rather than simply posting script and result. And where's the...

Wow, wasn't aware of this so thanks (went with 1 and 1).

Good job I always specify length so it hasn't cropped up before

kyle.doouss (1/25/2012)

---

I am wanting to split a string which can be a Max chars of 60 but not cut a word in half.

If you don't know what I mean please...

As roryp says, you haven't given us enough information to give you a satisfactory answer.

Please read this link[/url] about how best to provide us with working sample data and expected...

Paul's solution is probably better, but I hadn't realised we were meant to be totalling the minutes per department.

BEGIN TRAN

CREATE TABLE #Activity(ActivityId INT,DepartmentID INT,ActivityName NVARCHAR(100),ActivityStartDate DATETIME,ActivityEndDate DATETIME)

INSERT INTO #Activity (ActivityId...

Brandie Tarvin (1/24/2012)

---

Cadavre (1/24/2012)

---

Brandie Tarvin (1/23/2012)

---

The sample can be found here (in .pdf): http://www.crazy8press.com/wp-content/uploads/2012/01/Unlatched-teaser.pdf.

The blog post with the sample link is at: http://www.crazy8press.com/2012/01/12/sample-the-first-latchkeys-adventure/%5B/url%5D (in case you don't want to go...

Brandie Tarvin (1/23/2012)

---

The sample can be found here (in .pdf): http://www.crazy8press.com/wp-content/uploads/2012/01/Unlatched-teaser.pdf.

The blog post with the sample link is at: http://www.crazy8press.com/2012/01/12/sample-the-first-latchkeys-adventure/%5B/url%5D (in case you don't want to go directly to the...

I'm sure there's a better way, but this should be what you're after -

BEGIN TRAN

CREATE TABLE #Activity(ActivityId INT,DepartmentID INT,ActivityName NVARCHAR(100),ActivityStartDate DATETIME,ActivityEndDate DATETIME)

INSERT INTO #Activity (ActivityId ,DepartmentID,ActivityName,ActivityStartDate,ActivityEndDate)

VALUES ( 1,201,'Initial Review', '2010-01-05...

Had a quick look at it - your code will miss the precision/scale of decimal numeric data.

Try something like this: -

SELECT object_name(c.object_id),

t.NAME AS DATA_TYPE,

CASE WHEN t.NAME IN ('char','varchar','nchar','nvarchar')

...

SELECT DATA_TYPE,

CASE WHEN CHARACTER_MAXIMUM_LENGTH = -1 THEN 'MAX'

...

You should do this in the presentation layer, not...

A new Goosebumps was what I was after for her, she's read just about all of...

Brandie Tarvin (1/23/2012)

---

Cadavre (1/23/2012)

---

Brandie Tarvin (1/23/2012)

---

WHEEHAW!

Delayed due to technical difficulties, Latchkeys is now out on Kindle. Here's the U.K. Kindle version and here's the U.S. Kindle version.

The Nook versions...

Brandie Tarvin (1/23/2012)

---

WHEEHAW!

Delayed due to technical difficulties, Latchkeys is now out on Kindle. Here's the U.K. Kindle version and here's the U.S. Kindle version.

The Nook versions are supposed to...