Viewing 15 posts - 6,991 through 7,005 (of 7,168 total)
You'll want to convert the numerator and denominator to float or some form of a decimal before doing your division...sorry I did not consider it.
March 8, 2011 at 3:27 pm
Try this:
WITH cte(numerator, denominator)
AS (SELECT (SELECT COUNT(DISTINCT encounter) AS numerator
...
March 8, 2011 at 3:03 pm
SQL Server will implicitly convert your data in the text file to the destination data type per the table definition. That said, if you exported some data from Sybase and...
March 8, 2011 at 2:55 pm
I have seen Itzik talk about the USING clause for joins and the fact that it is missing from SQL Server. It is in the ANSI standard, but apparently not...
March 8, 2011 at 2:21 pm
Not that you won;t get help here, but you may be better off posting this in an SSRS forum: http://www.sqlservercentral.com/Forums/Group416.aspx
March 8, 2011 at 2:13 pm
Ken Davis (3/8/2011)
1. Download and install the Office 2007 connectivity components - http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en
2. Create and save an excel spreadsheet with column headers...
March 8, 2011 at 2:08 pm
PS When using regular load it looks like the commit size is 1 and I can't see a way to change it. This means a trigger on the table will...
March 8, 2011 at 1:11 pm
Khades (3/8/2011)
March 8, 2011 at 1:07 pm
It's pretty much just what it says...the character represented by hex 0x07 is invalid with respect to XML and one exists in the document at the position noted in the...
March 8, 2011 at 12:47 pm
tcloud (3/8/2011)
Where do I get access to the SQLServer Logs? is this through the SQLServer Studio?
In SSMS Object Explorer under Management.
Let us know if you get to the bottom...
March 8, 2011 at 12:36 pm
Check out this thread: http://www.sqlservercentral.com/Forums/Topic1011963-149-1.aspx
March 8, 2011 at 12:28 pm
Holly Kilpatrick (3/8/2011)
Using the login's current security context, the error is:Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)
Is this while logged into SSMS under your own...
March 8, 2011 at 12:20 pm
Is the outer proc Rpt_AccountsReceivableAgingSp the one returning the resultset? Or is it one of the called procs that is actually returning the resultset?
I have seen articles online that talk...
March 8, 2011 at 12:16 pm
I don't know if any of those messages are related to your issue.
I am kind of shooting in the dark here as this could be any number of things...
March 8, 2011 at 12:09 pm
Viewing 15 posts - 6,991 through 7,005 (of 7,168 total)