Forum Replies Created
Viewing 15 posts - 256 through 270 (of 363 total)
-
RE: SUM() returns exponent based value instead of 0
Can you convert the FLOAT into a fixed DECIMAL without loosing information?
Select SUM( Convert(Decimal(10, 5), TheFloatCol) )....
Once you understand the BITs, all the pieces come together
-
RE: Cursors
Basically a mechanism to navigate through a recordset record by record in T-SQL code.
Lookup FETCH and @@FETCH_STATUS in BOL.
Do you think you have a need to use a...
Once you understand the BITs, all the pieces come together -
RE: TempDB operations faster?
No, TempDB, Pubs, Master, all in same dir. Just a "stock" SQL install.
What are your results when running the script?
Once you understand the BITs, all the pieces come together -
RE: Date Format
Here's a shameless plug for a script I submitted...
http://www.sqlservercentral.com/scripts/contributions/1009.asp
Once you understand the BITs, all the pieces come together -
RE: Logshipping Copy/Load Schedule
To check file status, check out...
Thanks to this forum & David B.
Once you understand the BITs, all the pieces come together -
RE: Beta Test New Forums
When selecting "Quote" button from my last post at
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=19427#bm92095
I was returned....
Server Error in '/' Application.
--------------------------------------------------------------------------------
Ambiguous column name 'Approved'.
Description: An unhandled exception occurred during the execution of the...
Once you understand the BITs, all the pieces come together -
RE: Beta Test New Forums
"Update Post" returned:
Server Error in '/' Application.
--------------------------------------------------------------------------------
A potentially dangerous Request.Form value was detected from the client (Postmessage1:rteEditor="<P>Edit post test<FO...").
Description: Request Validation has detected a potentially dangerous client input...
Once you understand the BITs, all the pieces come together -
RE: Beta Test New Forums
The "Send Private Message To :" does not allow
1. editing of the body
2. Font / size /style selection etc.
Once you understand the BITs, all the pieces come together -
RE: Beta Test New Forums
Went to "Active threads", does not show to much... the "Sort by in From" dropdown has each time period twice. Selection of last 12 hours showed me only 1 very...
Once you understand the BITs, all the pieces come together -
RE: Only put a period "." if there is a middle intial.
As a side note, I've been asking MS for an ISNULL function in SQL-CE. I never thought of looking if COALESCE was part of the SQL-CE language since I always...
Once you understand the BITs, all the pieces come together -
RE: Result of dynamic query in variable
rohitkgupta, Did you ever get a solution?
Once you understand the BITs, all the pieces come together -
RE: Insert month if missing
Query your table with an OUTER JOIN against a table of dates (one record / month). Let us know if you need help making the [DATES] table.
Once you understand the BITs, all the pieces come together -
RE: JOIN VS CORRELATED SUBQUERIES
There are not to many absolute rules.
The writing of a query should 1st and foremost return the desired results. After that, much depends on the how the query is...
Once you understand the BITs, all the pieces come together -
RE: #Temp object curiosity
No specific reason, but I was looking at some old TSQL I wrote a while back, and asked myself "How does the #Proc persist?".
Thanks for the answers. It is...
Once you understand the BITs, all the pieces come together -
RE: variable tablename in cursor select stmt
What would be your max number of tables per @countyt?
I'm thinking something in the line of
(David's modified)
declare @sql nvarchar(4000)
set @sql...
Once you understand the BITs, all the pieces come together
Viewing 15 posts - 256 through 270 (of 363 total)