Re: Data style?

From: Steve Kass (skass_at_drew.edu)
Date: 02/03/05 

Date: Thu, 03 Feb 2005 01:24:41 -0500

Wendy,

  You will have to provide the data as character-based data,
preformatted as needed. You could try various solutions such
as these, shown with an integer variable @int and the getdate() function
instead of an entire table::

declare @int integer
set @int = 32476

select parsename(convert(varchar(20),cast(@int as money), 1),2)

select convert(char(10),getdate(),101)
select convert(char(10),getdate(),121)

Steve Kass
Drew University

Wendy W wrote:

>>Hi Wendy,
>>
>>The formatting of the output of a query is entirely up
>>
>>
>to the client. If
>
>
>>you access the same data using Query Analyser,
>>
>>
>Enterprise Manager, Access
>
>
>>and some other tools, you'll already see a variety in
>>
>>
>formats used, as
>
>
>>each of these tools has it's own defaults.
>>
>>Best, Hugo
>>--
>>
>>
>
>
>Thanks, Hugo but my situation is slightly different here.
>I'm supposed to display records in a data grip (ASP.NET)
>using the SQL statement. I can't format the data grid
>column to my desired format, the grid is dynamic.
>Therefore I need to format the fields in SQL statement.
>
>How can this be solved?
>
>

Relevant Pages

  • Re: [Lse-tech] [PATCH] new bitmap list format (for cpusets)
    ... came to the conclusion that the basic list format, ... So I redid the bitmap list format patch, ... A bitmap print and parse format that provides lists of ranges of ... extern int bitmap_parse(const char __user *ubuf, unsigned int ulen, ...
    (Linux-Kernel)
  • [PATCH] new bitmap list format (for cpusets)
    ... A bitmap print and parse format that provides lists of ranges of ... The intention is to provide a format for the cpu and memory mask files ... extern int bitmap_parse(const char __user *ubuf, unsigned int ulen, ...
    (Linux-Kernel)
  • [PATCH] new bitmap list format (for cpusets)
    ... [This is a copy of the bitmap list format patch that I submitted to ... A bitmap print and parse format that provides lists of ranges of ... extern int bitmap_parse(const char __user *ubuf, unsigned int ulen, ...
    (Linux-Kernel)
  • Re: Using References to Formats, Examining Scalars With Devel::Peek
    ... the format to be able to refer to it by another name didn't occur to me. ... Seems most of the fields are the same as for the rest of the Perl ... from integer to double and how frequently the string portions are updated. ... Using an operator or a built-in with a double and an int usually converts ...
    (comp.lang.perl.misc)
  • [patch 5/8] cpusets v3 - New bitmap lists format
    ... A bitmap print and parse format that provides lists of ranges ... extern int bitmap_parse(const char __user *ubuf, unsigned int ulen, ... * int nodemask_scnprintf(buf, len, mask) Format nodemask for printing ...
    (Linux-Kernel)