Viewing 15 posts - 3,136 through 3,150 (of 14,953 total)
Like this:
select *
from MyValuesTable
inner join MyScalesTable
on MyValuesTable.ValueFloat >= MyScalesTable.Scale
and MyValuesTable.ValueFloat < MyScalesTable.Scale + 1 ;
That assumes the scale range is 1 in all cases. If...
October 13, 2011 at 8:48 am
I'll just add to the "ignore Joe" votes. So far as I can tell, he has a template for all of his posts, and it plugs in every complaint...
October 13, 2011 at 8:33 am
Can you access it via a connection window? (Where you type queries and all that.)
If so:
alter database MyDatabaseName set multi_user;
October 13, 2011 at 8:27 am
Sorry, I can't help you on that one. I script my DDL actions. If I want to add a key, I just do it with an Alter Table...
October 13, 2011 at 8:25 am
Ninja's_RGR'us (10/13/2011)
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
BrainDonor (10/13/2011)
I know a few users I'd like to send into space.
Yup but the thing is they'll come back. Not really the best option...
October 13, 2011 at 7:32 am
Ninja's_RGR'us (10/13/2011)
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
BrainDonor (10/13/2011)
I know a few users I'd like to send into space.
Yup but the thing is they'll come back. Not really the best option for that.
I'd...
October 13, 2011 at 7:04 am
Ninja's_RGR'us (10/13/2011)
BrainDonor (10/13/2011)
I know a few users I'd like to send into space.
Yup but the thing is they'll come back. Not really the best option for that.
I'd go with...
October 13, 2011 at 6:26 am
Looks correct to me, and I don't get any error on it when I check it in SSMS. I can't run it, because I don't have the tables, but...
October 13, 2011 at 6:18 am
If it's that complex, a loop through the inserted table is probably the best bet.
But I can't imagine what running a 2000+ line proc on each row of a multi-row...
October 11, 2011 at 7:40 am
Since it can only insert into the target table, you can't use object.column naming in that context. Just the column names.
October 11, 2011 at 7:34 am
Have you tried fn_trace_geteventinfo to see what they're capturing?
October 11, 2011 at 7:32 am
eseosaoregie (10/11/2011)
My Apologies. I was counting the rows instead of summing them in the excel pivot. My Bad:blush:
That'd do it.
We all have those moments.
October 11, 2011 at 6:59 am
It's because run_date is an integer, and you're trying to add a string to it. Wrap h.run_date in a Cast/Convert to varchar, and it will do what you want.
October 11, 2011 at 6:42 am
Viewing 15 posts - 3,136 through 3,150 (of 14,953 total)