Viewing 15 posts - 2,521 through 2,535 (of 6,036 total)
viswa (4/29/2009)
If i giving the values like 10.25 i need a output as 10.00
My logic is
...
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...
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...
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...
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...
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...
April 28, 2009 at 10:53 pm
is250sp (4/28/2009)
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:
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...
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...
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
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...
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...
April 20, 2009 at 9:59 pm
Why QUOTED_IDENTIFIER is OFF?
April 20, 2009 at 4:58 pm
What we want to do for example is get a list of all HBA1c's and display them as a decimal value. But as in this example one is ABC...
April 20, 2009 at 3:53 pm
Viewing 15 posts - 2,521 through 2,535 (of 6,036 total)