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...
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...
May 22, 2016 at 8:30 pm
ringovski (5/19/2016)
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...
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,
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...
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.
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,...
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...
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".
May 10, 2016 at 5:11 pm
select
...
,growth/CASE is_percent_growth WHEN 0 then 128 ELSE 1 END as [amount growth]
...
FROM ...
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...
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...
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?
May 9, 2016 at 4:05 pm
Viewing 15 posts - 1,426 through 1,440 (of 6,036 total)