Viewing 15 posts - 736 through 750 (of 2,452 total)
could you please provide the results you are expecting from your sample query above...I think it will help clarify what you want.
Thanks
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2016 at 4:45 am
wwwnlc111 (5/7/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 7, 2016 at 9:35 am
wwwnlc111 (5/7/2016)
Well .BAT file copying files from one folder to other folder using robocopy command utility
are you saying that the SQL agent job fails or is just slow?
could be a...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 7, 2016 at 9:16 am
might be useful to consider divide by zero as well
DECLARE @Table_A TABLE
(id INT,
frs INT,
sec INT,
result DECIMAL NOT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 7, 2016 at 8:36 am
maybe
Update @Table_A set result = ISNULL(frs / sec,0)
select * from @table_A WHERE result = 0
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 7, 2016 at 8:21 am
will each combo of Product/metric have only one metric value?
edit....forgot to ask...how many unique metrics?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 7, 2016 at 6:50 am
what did google search throw up for you?
eg "ms sql script all agent jobs"
lot s of answers
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 6, 2016 at 2:54 pm
as Ed tried to tell you...
http://www.sqlservercentral.com/articles/Tally+Table/72993/
code is at bottom of this article.....strongly suggest you read the article and the associated discussion thread
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 6, 2016 at 1:08 pm
does every summaryline include the text that is in bold below?
Upper Right, Clinical Info for Radiologist: Bone Tumor; Additional Info to DI Tech: xxx please check
if so...maybe think about doing...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 6, 2016 at 12:54 pm
have you considered using ROW_NUMBER() ?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 6, 2016 at 12:00 pm
R.P.Rozema (5/6/2016)
mock up some example table and generate a significant volume of test data into it
some test data......and yeah the generic audit is slow.
Personally I only use this for...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 6, 2016 at 6:52 am
maybe....
CREATE TABLE #MEMBERS (
MEMBERID INT,
SESSIONID INT
)
INSERT INTO #MEMBERS
SELECT 1,1
UNION
SELECT 1,2
UNION
SELECT 2,1
UNION
SELECT 3,1
UNION
SELECT 3,2
UNION
SELECT 3,3
CREATE TABLE #SESSIONS (
SESSIONID int
)
INSERT INTO #SESSIONS
SELECT 1
UNION
SELECT 2
UNION
SELECT 3
SELECT
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 6, 2016 at 5:38 am
Jeff Moden (5/5/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 6, 2016 at 1:25 am
Jeff Moden (5/5/2016)
J Livingston SQL (5/5/2016)
Jeff Moden (4/28/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 5, 2016 at 2:20 pm
Jeff Moden (4/28/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 5, 2016 at 1:41 pm
Viewing 15 posts - 736 through 750 (of 2,452 total)