Viewing 15 posts - 1,426 through 1,440 (of 6,036 total)
In your data sample you've got only 6 unique diagnosis codes.
Are you sure you need to repeat them all over and over again in that row you need to populate?
Is...
_____________
Code for TallyGenerator
May 22, 2016 at 9:39 pm
I guess you need to express your intentions inside of "OVER()" clause in your query.
If you want to do counting not over the whole period but over its parts than...
_____________
Code for TallyGenerator
May 22, 2016 at 8:30 pm
ringovski (5/19/2016)
_____________
Code for TallyGenerator
May 19, 2016 at 11:44 pm
Currency conversion rates are not fixed, you know.
They change every day.
To pick the right rate for any particular invoice you need to have a table with conversion rates between all...
_____________
Code for TallyGenerator
May 18, 2016 at 11:54 pm
deep_trance_ (5/17/2016)
exec sp_msforeachdb 'select "?" AS DatabaseName, OBJECT_NAME(c.OBJECT_ID, DB_ID(''?'')) as TableName,
_____________
Code for TallyGenerator
May 17, 2016 at 10:15 pm
Eirikur Eiriksson (5/11/2016)
GilaMonster (5/11/2016)
Eirikur Eiriksson (5/10/2016)
One could argue that 153000 userlookups indicates that other indices should be created, key lookup is quite expensive operation.
Since key lookups are only ever done...
_____________
Code for TallyGenerator
May 15, 2016 at 5:13 pm
Inside of a stored procedure you may use OBJECT_NAME(@@PROCID)
This will work for triggers as well.
_____________
Code for TallyGenerator
May 11, 2016 at 7:22 pm
For the sake of fun:
You might wish to convert to other integer data types, not only int.
Try to use different types for @tgt in this script:
Declare @hex VARCHAR(50), @tgt TINYINT,...
_____________
Code for TallyGenerator
May 10, 2016 at 9:09 pm
Check if you can find this function in master database on SQL2005.
But this works on SQL 2008:
Declare @hex VARCHAR(50)
Select @hex = '0x' + '009FF000' -- I added missing zero in...
_____________
Code for TallyGenerator
May 10, 2016 at 8:59 pm
douglasbrown880 (4/14/2016)
the issue is the same
And it has a name.
It's name is "MERGE".
_____________
Code for TallyGenerator
May 10, 2016 at 5:11 pm
select
...
,growth/CASE is_percent_growth WHEN 0 then 128 ELSE 1 END as [amount growth]
...
FROM ...
_____________
Code for TallyGenerator
May 9, 2016 at 7:58 pm
R.P.Rozema (5/9/2016)
Even though the solution presented here has serious limitations (and I think serious flaws too),
I wonder who can see more of them - me or you? 🙂
I sense...
_____________
Code for TallyGenerator
May 9, 2016 at 4:36 pm
J Livingston SQL (5/9/2016)
I think that you need some code somewhere to populate dbo.Audit_TableColumn ??
The idea is to populate it from some kind of "admin config" front end application.
And the...
_____________
Code for TallyGenerator
May 9, 2016 at 4:21 pm
o103452 (5/6/2016)
I'm wondering if there's there a way to improve the current query
What current query?
_____________
Code for TallyGenerator
May 9, 2016 at 4:05 pm
What this task has to do with SQL?
_____________
Code for TallyGenerator
May 9, 2016 at 5:09 am
Viewing 15 posts - 1,426 through 1,440 (of 6,036 total)