Can you convert the FLOAT into a fixed DECIMAL without loosing information?

Select SUM( Convert(Decimal(10, 5), TheFloatCol) )....

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...

No, TempDB, Pubs, Master, all in same dir. Just a "stock" SQL install.

What are your results when running the script?

Here's a shameless plug for a script I submitted...

http://www.sqlservercentral.com/scripts/contributions/1009.asp

To check file status, check out...

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=19344&FORUM_ID=9&CAT_ID=1&Topic_Title=How+to+test+DOS+%22file+in+use%22+status%3F&Forum_Title=General

Thanks to this forum & David B.

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...

"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...

The "Send Private Message To :" does not allow

1. editing of the body

2. Font / size /style selection etc.

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...

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...

rohitkgupta, Did you ever get a solution?

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.

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...

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...

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...