Viewing 15 posts - 2,521 through 2,535 (of 6,037 total)
viswa (4/30/2009)
But my exact input length of parameter is numeric(18,7)and output is numeric(18,7)
that time your condition will not work so make me exact..
Then you need to make some effort in...
_____________
Code for TallyGenerator
April 30, 2009 at 12:32 am
viswa (4/29/2009)
If i giving the values like 10.25 i need a output as 10.00
My logic is
...
_____________
Code for TallyGenerator
April 30, 2009 at 12:04 am
john.arnott (4/29/2009)
Now, if we're lucky, someone can help us figure out a single pass solution.
Solution was posted here many times, and Jeff Moden even made an article out of his...
_____________
Code for TallyGenerator
April 29, 2009 at 8:35 pm
Bob Griffin (4/29/2009)
Select e_ina11,E_Create_Date,e_Org_FileName From Element
Where coalesce(e_Ina11,1) = 1
AND...
_____________
Code for TallyGenerator
April 29, 2009 at 7:03 pm
is250sp (4/29/2009)
correct, do you have any other ideas?
The idea is simple.
For each user you build a report string using one of "concatenation functions" posted on this forum.
It would be a...
_____________
Code for TallyGenerator
April 29, 2009 at 5:43 pm
Kaushik Majumder (4/29/2009)
Facing some issues with the following query....
Select e_ina11,E_Create_Date,e_Org_FileName From Element
Where e_Ina11 Is Null
AND E_Create_Date > '2007-12-31'
And e_Org_FileName Like '%].xls%'
The reslutset,however, includes non null values for column...
_____________
Code for TallyGenerator
April 29, 2009 at 5:09 pm
Why you need #YTD at all?
I believe Jeff Moden was trying to teach you how to do cross tab queries...
_____________
Code for TallyGenerator
April 28, 2009 at 10:53 pm
is250sp (4/28/2009)
_____________
Code for TallyGenerator
April 28, 2009 at 10:33 pm
Jeff Moden (4/27/2009)
I don't allow such garbage into my db's to begin with. 😛
I believe this is the method that doesn't suck so much.
:hehe:
_____________
Code for TallyGenerator
April 28, 2009 at 10:29 pm
Jeff Moden (4/27/2009)
GSquared (4/27/2009)
To deal with times that don't have enough leading zeroes, you can either padd the string, or you can reverse it. Either one works.
As is usually...
_____________
Code for TallyGenerator
April 27, 2009 at 11:18 pm
Lowell,
Second LEFT JOIN leave a possibility for the query to return all Backup History records with different Backup_Size. As a result you'll have multiple records for the same DATABASE_NAME.
You need...
_____________
Code for TallyGenerator
April 26, 2009 at 11:03 pm
If one of the statements fails your procedure leave the transaction open.
Completing of procedure code does not complete transaction.
it should be like this:
if @ierror=0
begin
commit transaction
end
ELSE
begin
rollback transaction
end
_____________
Code for TallyGenerator
April 22, 2009 at 7:32 pm
bitbucket (4/21/2009)
Have you looked at ROW_NUMBER (Transact-SQL) in BOL? It is very useful and quite fast for listing duplicates.
Did you ever try it on 40+ mil tables?
Not to...
_____________
Code for TallyGenerator
April 21, 2009 at 4:41 pm
Set up a linked server to text file and load from the file like from remore table.
Or use OPENQUERY.
See BOL for details. Topic "Linked Servers".
Example from there:
--Create a linked server.
EXEC...
_____________
Code for TallyGenerator
April 20, 2009 at 9:59 pm
Why QUOTED_IDENTIFIER is OFF?
_____________
Code for TallyGenerator
April 20, 2009 at 4:58 pm
Viewing 15 posts - 2,521 through 2,535 (of 6,037 total)