CELKO (8/7/2012)

---

Why not use a Calendar table with whatever fiscal or reporting years you use? The GAAP had 250+ the last time I looked. SQL is not a computional ...

Sean Lange (8/7/2012)

---

I appreciate the effort of the poster but I am still not quite sure what we are trying to test. Commenting in dynamic sql or the scope of...

Thomas Abraham (8/7/2012)

---

+2 - This question has GOTCHA written all over it. While I admit I should have been more careful in reading the question, the question title and the...

tommyh (8/6/2012)

---

So here i was thinking this was a rewrite of the question we had 2 questions ago, since this question had the varchar(50) on str4 which would have fixed...

I fill in the calendar table with a dump from an 11,000 integer tally table. It reaches out about 30 years. I have a process that checks nightly...

Add a calendar table with a working_day field type int =1 on working days, and 0 on non-working days.

i.e.

CREATE TABLE dbo.calendar(

calendar_date date NOT NULL PRIMARY KEY,

working_day INT NOT NULL DEFAULT...

Put me in the group of learners...

Knew the first two. Have never played with either XML or SPATIAL data types as of yet (curious about them, haven't had a...

capn.hector (8/3/2012)

---

Well here is my solution. since we can order by when we take our substring we can just put the FOR XML PATH ('') in that query and...

It's hard to tell when the SQL script is an image.

I'm sure this will come down to some kind of argument, but when I see the image

I don't see...

My turn

DECLARE @num INT = 102948092

DECLARE @numstr VARCHAR(10)

SET @numstr = @num

DECLARE @tab TABLE(

num INT,

numc CHAR(1))

;WITH

t1 AS (SELECT 1 N UNION ALL SELECT 1 N),

t2 AS (SELECT...

rja.carnegie (9/17/2009)

---

I need to read this article carefully, but my immediate reaction is that the indexes that aren't used or don't even exist are the ones that should be considered...

+1 I agree.......

1 Production Environment

3 Full Backups + 12 Differentials + 36 Transaction log backups on the production server

1 Staging Environment

1 Full Backup copied from Production at some ponit

1 Development Environment

1 Full...

Thanks for making me think... I had to sit there and keep reminding myself how the datetime2 values would round and then tried to keep two mental counts (statement 1...

mtassin (7/30/2012)

---

What has always mattered to me was the percentage of questions I've gotten correct. I have a personal goal to keep my % correct value above the site's...