Also, binary != hex (0b10001 = 17)

...is Jack Corbett's current points total.

TheSQLGuru (1/24/2012)

---

2) cursors are still the fastest supported way to do running totals in sql server. Jeff Moden and others have come up with the "quirky update" to do these...

It's also the first five binary digits of 10001001 - a number I seem to recall has special significance to you 🙂

Congratulations, Jack!

SQLKnowItAll (1/24/2012)

---

Just curious... In your sample data are you giving us the entire actual table, or not? My guess is that there is a clock in datetime and a...

SELECT

RIGHT(100 + (Grouped.TotalMinutes / 60), 2)

+ ':' +

RIGHT(100 + (Grouped.TotalMinutes % 60), 2)

+ ':00'

FROM...

Good question.

CREATE FUNCTION dbo.Hash_SHA (@data nvarchar(200))

RETURNS TABLE WITH SCHEMABINDING AS RETURN

SELECT HASHBYTES('SHA', @data) AS hash_value

GO

-- Returns 1 (true)

SELECT

OBJECTPROPERTYEX(OBJECT_ID(N'dbo.Hash_SHA', N'IF'), 'IsDeterministic');

aitchkcandoo (1/23/2012)

---

Not the main point but I wondered why you used Count_Big for a column whose value, invoice_number is int. per msdn.microsoft.com "COUNT_BIG always returns a bigint data type...

Different; better is always subjective 🙂

DROP TABLE #Activity

CREATE TABLE #Activity

(

ActivityId integer NOT NULL,

DepartmentID integer NOT NULL,

ActivityName nvarchar(100) NOT NULL,

...

It worked for the sample data you provided :hehe: :hehe: :hehe:

Look, images are not easy for us to work with...

Oh I wouldn't say that - perhaps it's just T-SQL hasn't got that far yet...

See CONTAINS (http://msdn.microsoft.com/en-us/library/ms187787.aspx) in Books...

kirkdm01 (1/23/2012)

---

Im new to SqlServer I was wondering if you had a record with a field that is an Integer which allows null and has a value of 1 can...