Forgot your password?
typodupeerror

Comment: Re:Haven't done T-SQL in years (Score 1) 6

by Marxist Hacker 42 (#47437797) Attached to: Fun with SQL Server 2012

I didn't explain the behavior adequately.

SELECT * FROM dbo.GetReferencedModelPointsByJobID(@JobID)

Returns someplace between 2-56 rows, depending on JobID

The second query does NOT error out, but is not returning a comma delimited string of all rows, but instead, in some cases, is returning only ONE row.

Since I'm using this to build a temp table, it doesn't error out until I attempt to fill columns in the temp table that do not exist.

User Journal

Journal: Fun with SQL Server 2012 6

Journal by Marxist Hacker 42

I have a Table Valued Function that returns a simple parameterized view. I want to turn that view into a string.

Can anybody tell me why the first query works and the second one doesn't?

DECLARE @JobID INT
DECLARE @strOut VARCHAR(MAX)

SET @JobID=2861

Comment: Re:Automated troubleshooting? (Score 1) 247

by HBI (#47432675) Attached to: Ask Slashdot: Unattended Maintenance Windows?

That is not true. If my job is important and my systems are important, i'm on site to make sure that change is successful.

When I was with IBM, our policy was to open up a conference call and have all the requisite support staff on the call until the change window closed. You paid through the nose for that kind of support, but our downtime was minimal and some customers needed that.

When I am working in theater on critical systems in wartime, I don't sit in my fucking hooch and use automated tools. My ass is in front of the boxes in question to respond instantly. The alternative is broken tactical systems meaning bad information being used to make decisions meaning dead people.

Your slack attitude doesn't cut it in the places I work.

The first Rotarian was the first man to call John the Baptist "Jack." -- H.L. Mencken

Working...