Within SQL Server the max precision (or "length") of a number is 38.

So, you could use

SELECT convert(numeric(38,0),cast(@t AS float))

But you have to be careful for several reasons:

1) if you...

What level of experience do you have with SQL Server?

If none or limited, I recommend to either get some training or to have a 3rd party involved doing the conversion...

Did you consider BOL (BokksOnLine, the SQL Server help file) as a source?

Please see chapter "cross apply" for details. There is an example as well.

Even though the example shows the...

The beginning of the XML (<bookstore='MomnPop' ) is not considered as a well formed xml.

For two reasons:

1) you cannot assign a value to an element if you assign attributes to...

Several questions:

1) Does "4 weeks" mean to calculate the average for full weeks or is 4 weeks = last 28 days? Based on your example: Dec. 15th is a Tuesday....

You might want to have a look at BOL (BooksOnLine, the SQL Server help system installed together with SQL Server).

Search for CREATE FUNCTION (Transact-SQL) , Example A.

Did you read the articles I referred to in my previous post?

What help do you need exactly? If it's a "how to" in general, I would recommend you try the...

closing bracket before the GROUP BY is missing.

AND ( [tblGL code percent cost allocation].[GL Code] = [tblGL Codes (Determine GL 2)].[GL 2] )

Note: This would be much easier to find...

Would you mind sharing some sample data for column [description] representing some input scenarios (e.g. 10 to 20) together with expected results per row?

Do you have a guaranteed order of...

Even though I still don't know why an integer column needs to be converted into a character data type... Here's how I'd do it if I'd be forced to:

Step 0:

Verify,...

Sandy,

like Chris mentioned before, we'd like to see your input data as well as your expected results. The "sample" you provided is everything but clear.

Example:

Sample1

XYZ

111,29th Main, ABCD - 10002

What does...

Update YourTable

SET YourTable.Col1 = ' '

WHERE YourTable.Col1 < 0

But there are (at least) two remaining question:

If you care about performance, why do you want to use a character (space) within...

You can receive the data from SQL Server by using the FOR XML clause. With some additional effort it's even possible to get complete html pages (but text formatting would...

Try to query as unicode data format:

like N'??????????' (or like N'%????????%' if you'd need to use wildcards)

instead of

like '??????????'

Hope that helps.

As asked for before: table def and some sample data, please.

Preferred in a ready to use format as described in the aforementioned article.

And no, there is no function like...