|
|
|
July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
convert from hexadecimal to a decimal Posted by Skip at 9/28/2004 6:43:44 PM We have a tableA with a varchar field whose contents are
hexadecimal. We want to insert these hexadecimal contents
from a varchar field into different table, tableB in
decimal format.
We tried to use Cast and convert functions to explicitly
convert into int field thinking it will give us...more >>
How do i perform a case sensitive search?? Posted by Michael at 9/27/2004 11:09:21 PM i've just realized i've installed my mssql to be case-insensitive, now all
my queries seems to be case insensitive.
Is there any workaround?? How should i write my sql statements to be case
sensitive now??? because i get the same results for:
1:
select * from members
where user = 'abc'
...more >>
Number to Date Posted by Miguel Salles at 9/27/2004 10:59:04 AM Hi,
I have a legacy system that uses a strange date format, wich I'd like to
convert for datetime on a new table.
The date is in this format: 104001(2004-01-01), 104002(2004-01-02),
104271(2004-09-27)
I think that I'll have to break the problem in two parts:
The year - three first digits ...more >>
SUBSTRING question Posted by Skip at 9/27/2004 8:12:04 AM I have a field that is made up of several important values
all in one string. (Location.Serial# + '-' + ID). I need
help seperating this field in a query. I can use Substring
to take everything to the right of the '-'. Can anyone
tell me how to use substring to parse the information to
the...more >>
Query can not be executed in SQL Enterprise Manager Query Designer on W2000 Serv Posted by Juan_Carlos_Hidalgo_Macré at 9/24/2004 10:01:59 AM The following error message when you execute queries in
the Query Designes throuht SQL-Server Entreprise Manager
(SEM):
The query cannot be executed because some files are either
missing or not registered.
I am reinstallation of the SQL Server 2000 Client Tools
does not correct the prob...more >>
Sequel query pulling up duplicate data Posted by Mark at 9/23/2004 7:37:46 AM Not sure if this is the right forum, if not, please
direct me.
When I create a link to a SQL 2000 server database via
Dreamweaver MX, for some reason on one account retrieved,
it pulls up duplicate data. The other acounts appear
fine.
When a customer pulls up their account history, th...more >>
format a numeric values with commas Posted by hari at 9/23/2004 2:24:33 AM hi Steve,
Thanks for that. it is working fine.
But for the whole numbers like 123456 it is not doing so.
it is formatting to 1,234,567.00 (with two zeroes after
decimal). i want it to be formatted as 1,234,567
how to format 1234567 to 1,234,567
thanks,
hari.
>-----Original Mes...more >>
how to suppress zeroes after decimal and whole no. should remain same Posted by hari at 9/23/2004 1:20:25 AM hi ,
but it is not working for whole number like ex:11120
it is fetching it as 11120. (with point at the end)
how to do that.
thanks,
hari.
>-----Original Message-----
>see following example:
>
>drop table test
>create table test(c1 decimal (15,5))
>insert into test values (3.5...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
how to suppress zeroes after decimal point at the end in a value Posted by hari at 9/22/2004 11:31:03 PM hi,
i have a sql table field price and datatype is
decimal 13(20,6).
when i insert values to this field, values are being
inserted correctly. i.e. 13.45 inserted as 13.45 and
145.653 inserted as 145.653 only.
But while fetching only the values are coming as 13.450000,
145.653000, bec...more >>
CHECK DOUBLE RECORD Posted by MA at 9/22/2004 9:04:51 PM hi,
I've problem to check row which having duplicate value
for fieldA and fieldC.
Eg.
rec 1
fieldA fieldB fieldC
50000A 123456 A
rec 2
50000A 654321 A
Thanks.
...more >>
part removal Posted by GW at 9/22/2004 6:23:19 PM Hi,
I've a problem to remove certain character from one
column/field eg. 500000000000ABC. How to remove ABC ?
Thanks in advance....more >>
format a numeric values with commas Posted by hari at 9/22/2004 3:03:19 AM hi,
I have requirement.
I want to format a numeric value with commas. is there
any function to use in transact-sql query to do this.
for example if the numeric value is 27519.37 then it
should be formatted as 27,519.37
if the numeric value is 1221512.34 then it should be
formatted as ...more >>
SQL problems Posted by Cormac Mannion at 9/21/2004 7:25:49 AM Hi! I ran the upgrade pack for Microsoft last night and
now my localhost on my laptop won't work. I use SQL to
demonstrate a website on the laptop but the "homepage" -
http://localhost won't open.
Any ideas?
Thanks!!!!...more >>
format a numeric values with commas Posted by hari at 9/21/2004 3:49:34 AM hi,
I have requirement.
I want to format a numeric value with commas. is there
any function to use in transact-sql query to do this.
for example if the numeric value is 27519.37 then it
should be formatted as 27,519.37
if the numeric value is 1221512.34 then it should be
formatted as ...more >>
NOT IN Query Returns No Results Posted by Baner at 9/17/2004 9:14:58 AM When running the following query and subquery with a NOT
IN clause, I'm getting no results with SQL Server 2000
SP3. Has anyone seen this before ?
=======================================
select * from T_TEST_PB_091704
where acct_or_lvl_nm not in (
select distinct PAR_MEMB_ALIAS_TXT C...more >>
how to convert varchar into smalldatatime Posted by new at 9/16/2004 1:07:03 PM I import text file into SQL table, one column
name 'date', datatype is varchar and string in field
like 'dd/mm/yy'. I want to convert varchar into
smalldatetime and output is 101 'mm/dd/yyyy'. my query is:
alter table name1 alter column date smalldatetime
error massage:Server: Msg 296, L...more >>
How to Convert Character String to Numeric- Thanks! Posted by anonymous NO[at]SPAM discussions.microsoft.com at 9/16/2004 11:24:48 AM How to convert character string to numeric? Thanks!...more >>
passwrd Posted by shif at 9/13/2004 7:56:43 AM Hi
i am new in mssql7.Using sp_password i put login password
for the server.How can i put a password for a particular
database in the server.
Thank you....more >>
error: when insert into table Posted by new at 9/10/2004 1:01:46 PM Violation of PRIMARY KEY
constraint 'PK__tablename__182C9B23'.
Cannot insert duplicate key in object 'tablename'.
The statement has been terminated.
Thanks reply...more >>
Server identifier Posted by mariela_montero NO[at]SPAM ncsu.edu at 9/10/2004 7:38:23 AM
I am working with sql server trying to conect to a sybase
server. Trying to use the following statement:
exec open_acs_dds...rp_sqlredirect hrl_extract,"select *
from hrl_fall_99_id_view where ID>'000000100' and
((BldgName>'A' and BldgRegion <>'V') or HousingStatus
like 'C%') order by
...more >>
Sql Northwind DB Posted by arva at 9/6/2004 2:47:34 PM Please send me the answers to the following questions.
This is very urgent,use the northwind Database in Sql
server to build your query.
1.Provide a SQL statement and sample result set that will
list all Customers within the CA state.
2.Provide a SQL statement and sample result set that ...more >>
Disable SQL Posted by VintageRad at 9/6/2004 1:29:51 AM Hi
I use SPSS for Windows on XP (HE). My system nearly came
to a halt recently, and I noticed SQL.LOG was a
fragmented text file (830 Mb) on C drive. I opened a new
text file and saved it as SQL.LOG in the same location.
This solved my problem, but I don't know how to disable
SQL and I...more >>
Update statment with two databases Posted by Chieftonw at 9/3/2004 1:35:03 PM I am just starting to work with SQL c0ommands and have what I hope is an easy
question.
Basically I am working with two databases, which contain the same tables
(same table keys). However I want to update one of the columns in one of the
databases to the value from another. How can I use ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |