Peter Tirrell

Age: 35

Jun
30
answered Different login views in Pyramid
Jun
26
comment script task bulkcopy from Excel to Sql Server 2008. Missing row
When you move the offending row to the bottom of the worksheet, does the new 'first row after the header' get loaded?
Jun
22
answered Web service restart at boot time
Jun
17
comment How can I extract the value of a varbinary(max) column?
If it's still not working then you might also try using the bcp command to create an exported data file and then use the same command to import it into your destination after creating empty table structures.
Jun
17
awarded Yearling
Jun
17
awarded Yearling
Jun
17
answered How can I extract the value of a varbinary(max) column?
Jun
15
answered Search box/field design with multiple search locations
Jun
12
answered Getting highest primary key for specified column value
Jun
12
answered Is "Version" a Reserved word in TRANSACT-SQL? (Shows Blue but not in Reserved word list)
Jun
10
comment Select rows that if i sum thier value = 0 from table
What if more than one combination of rows will total to 0? I.e., if there were rows: 7. AGF 10.00, 8. AGF -10.00 ? Would you get 1,3,6, then 7, 8, and 1,8, and 6,8, etc.?
Jun
9
awarded Nice Question
Jun
5
comment Can ReSharper automatically add missing references?
Arguably, doesn't Netbeans already do something like this?
Jun
5
accepted Can I plug a multi-outlet adapter into a GFCI outlet?
Jun
5
awarded Curious
Jun
4
asked Can I plug a multi-outlet adapter into a GFCI outlet?
Jun
4
comment Incorrect SQL Syntax with nested Select statements in Crystal Reports
Something like this? Something like this I think: DECLARE @OUTPUT TABLE (CompDaysHigh int, CompDaysLow int, RespDaysHigh int, RespDaysLow int, WOTotal int, WONow int, WOHigh int, WOLow int, NumberMetGoalHigh int, NumberMetGoalLow int) INSERT INTO @OUTPUT SELECT blah value FROM... UPDATE @OUTPUT SET blahothercolumn = value from next query And then you can have your individual UPDATE statements continue on from there...
Jun
4
answered Incorrect SQL Syntax with nested Select statements in Crystal Reports
Jun
4
comment Incorrect SQL Syntax with nested Select statements in Crystal Reports
Like what Zohar is referring to, I think you're trying to do too much in a single query to get the results that you're trying to get; the SQL syntax you're trying just won't work that way. Can you use separate data sets? I'm going to try my hand at an answer that hopefully might point you in a good direction.
Jun
3
comment Incorrect SQL Syntax with nested Select statements in Crystal Reports
Can you use a table variable or CTE or is the above query generated from Crystal? I think you'll need to refactor it a bit...it looks like you're trying to aggregate a number of different single-value results but then your last nested query will return multiple rows. If you are doing this in a stored procedure that will get called then I would suggest breaking it down into smaller subpieces within your process and put it back together at the end. To that - what do you expect your final data set to look like?
1 2 3 4 5