Hi Group,
Wich datatype can I best use for a number with several decimals (can be anything between 1 and e.g.10)
If the number has 10 decimals the customer needs the EXACT numbers. They couldn't explain why....
TIA
Regards,
Sander
Hi,
I've the sql code below wich give interesttarget 78 as a result wch I shouldn't. I think it has something to do with the'(' and ')' .
SELECT Top 5 *
FROM TestnetCampaign a, TestnetAds b
WHERE a.campaignid = b.campaignid
AND b.sizeid = 21
AND (
a.interesttarget LIKE '10,%'
OR a.interesttarget LIKE '%,10,%'
OR a.interesttarget LIKE '%,10'
)
AND (
a.interesttarget NOT LIKE '78,%'
OR a.interesttarget NOT LIKE '%,78,%'
OR a.interesttarget NOT LIKE '%,78'
)
ORDER BY a.ecpc DESC
Any suggestions?
Thanks!
Roel
Hello, if i have
TABLE ITEMS
ItID(PK) | ItName
---------------------------------------------------------------
1 Bike
2 Car
3 Boat
TABLE DET
ItID(PK)(FK of ItID) | Detail
---------------------------------------------------------------
1 Mountain
1 With Suspension
2 5 Airbag
2 3500 c.c.
2 215cv.
3 with cabinet
And i want a table result like
ItId ItName Detail
---------------------------------------------------------------
1 Bike Mountain
2 Car 5 Airbar
3 Boat with cabinet
WHAT "JOIN" I NEED TO USE OR WHAT QUERY I NEED TO WRITE. CAN ANYONE WRITE ME THE QUERY, that as i show in example, will return only the first Detail for each Item
Hi,
Wich collation should I use for the right display of the euro character? I now get a '?'.
Thanks!
Roel
Hi, i'd like to try Express2005 but before i'd like to know
wich are the limit vs Sql Server.
I had seek in Microsoft's site but i haven't found it
anyone kwon it ?
Thank's for the answer
Daniele Pinai
(Italy)
Hello friends !
Wich one is more efficient way to use a sql mdf file in Sqlexpress ?
attaching a mdf file on sqlexpress ( and use initialcatalog in connection string ) or use AttachDbFilename on connection string directly ?
Is there any difference in performance and speed ?
Thanks a lot
I kow for a solid comparison between using datareaders and datasets I will have to perform that myself. But for now I will be utilizing datasets...
What I am doing is currently utilizing assemblies to create my datasets ahead of time. I will eventually compile them as dlls. I'm just utilizing assemblies during my building/testing fase.
My questions is:
Is it faster to completely build the datasets and all needed connections inside the assemblies/dlls and fill them? Or to build the datasets and connections as a sub procedure that can be accessed and then fill them as each required set of data is needed?
I ask because I will be having many different data connections and so I'm not sure if it's faster to explicitly build/fill almost each and every one and have them compiled at runtime ready to be accessed, or to file them when called from a sub etc...?
As I take it, the server should track and monitor which are used the most, and cache them, so as to operate faster. I wonder if it will still do this if the datasets aren't pre-filled?
Hi,
I have a table customer wich has the columns phone_number(char type) and ok_to_call(bit type). There are already data in the table and the column ok_to_call only contains the value false for every row.
Now i want to update the latter column. I have a text file with a list of phone numbers and i want that all the rows in the Customer table(phone_number column)that matches the number in the text file to update ok_to_call to true.
This is to be done in SSIS(Integration Services). I'm new at this and i've looked around that tool but is a lot of items, packages and stuff so i dont know where to begin.
Would appreciate help on how to solve this issue in SSIS. What controlflow/Data flows to use,wich items and packages to use, how to configure and how to link together?
Regards
/Tomas
ciao a tutti...ci risono...devo migliorare delle performance di accesso ad una tabella...la tabella non ha indice primario, ne altri indici...sulla tabella ci accedo con select di questo tipo..select @ExistInOAG = count(*)FROM caprs05dev.dbo.OAGWHERE Air_Carrier = @Aircarrier andcast(ltrim(rtrim(Flt_nbr)) as int) =cast(ltrim(rtrim(@ComFltNbr)) as int) andAipt_Dpt = @AIPTDep andAipt_Des = @AIPTDst andDT_FLIGHT = @Date_Rif andconvert(varchar, STD, 102) = convert(varchar, @STD,102) andconvert(varchar, STA, 102) = convert(varchar, @STA,102)ho provato a creare diversi tipi di indici, ma le performance migliorile ottengo se lascio stare tutto come era senza nessun'indice!!!! visembra possibile???le prove che ho fatto sono queste...inserire un indice tipo Primary con i campiFlt_nbr,Aipt_Dpt,Aipt_Des,STD,STAcreate Unique, tipo Index, con Ignore duplicate key...create as clustered checcato e fill factor 100%... ci accedopraticamente solo in select nel file...avete consigli per migliorare le performance di accesso allatabella????grazie.. stefano!!!
View 2 Replies View RelatedNeed to know if the varchar datatype field will ingore leading zeros when compared with numeric datatype ?
create table #temp
(
code varchar(4) null,
id int not null
)
insert into #temp
[Code] .....
Good afternoon,
I have an issue with an ssis variable datatype.
The scenario is as follows:
I have a stored procedure:
PROCEDURE [dbo].[sp_newTransaction]
@sourceSystem varchar(50),
@txOut NUMERIC(18,0) OUTPUT
AS
insert into scn_transaction (sourceSystemName) values(@sourceSystem);
SELECT @txOut = @@identity
Whose purpose is to perform an insert into a table and return me the identity value of the inserted record, which I'll then use throughout the rest of my package. The identity column in the inserted table is numeric(18,0).
I execute the stored proc with the following sql with an OLE DB connection manager:
exec sp_newTransaction ?, ?
The first parameter is a string variable from earlier in the package, and the second is the output parameter. I have the following parameter mappings to the execute sql task:
User:ystxId output numeric 1 -1
User:ourceSys input varchar 0 -1
The proc is correctly called, and the row insesrted, however I get a type conversion error when SSIS attempts to map the return parameter to my package variable... I've tried all sorts of combonations, and can't seem to get it to execute.
At one point I wasn't returning a numeric, but rather an int from the stored proc, and all was well until I went to use the variable in a derived column later in the package, and the type was converted quite incorrectly (a 1 was 77799789080 or some such), indicating a type conversion error likely related to the encoding of the number.
I'd like to keep the datatypes as numeric and make ssis use those - any pointers are greatly appreciated as to what type my package variable should be to allow proper assignment of a sql server numeric type to it.
Thanks much,
B
Database is SQL Server 2000
I have a field in a table that stores date of birth. The field's datatype is char(6) and looks like this: 091703 (mmddyy). I want to convert this value to a datetime datatype.
What is the syntax to convert char(6) to datetime?
Thank you in advance.
Hi,
I imported a table from Accees to SQL 7 with data in it.
I need to modify one of the datatype columns to "datetime" from nvarchar.
I tried to convert it manually, in SQL Server Enterprise Manager tool, but it gave me an error.
I also tried, creating another column "DATE2-datatype:datetime" and updating the column with the old one.
UPDATE users SET DATE2 = DATE.. But it also faild,..
How can I modify the column?
Thank you.
HI,I have a table with IDENTITY column with the datatype as INTEGER. Nowthis table record count is almost reaching its limt. that is totalrecord count is almost near to 2^31-1. It will reach the limit with inanother one or two months.In order to avoid the arithmentic overflow error 8115, we would likechange the datatype from INT to BIGINT. we hope this will solve ourproblem.How do I approch this datatype conversion?. Since the data count ishuge, that leads to a long down time of database.we need better approach or solution for this problem?. kindly give mea better solution that will reduce the total downtime of the productiondatabase.?.Regards
View 1 Replies View Related
Hi guys..
i have so doubts in my mind and that i want to discuss with you guys... Can i use more then 5/6 fields in a table with datatype of Text as u know Text can store maximu data... ? acutally i am trying to store a very long strings values into the all fields. it's just popup into my mind that might be table structer would not able to store that my amount of data when u use more then 5/6 text datatypes...
and another thing... is which one is better to use as data type "Text" or "varchar(max)"... ?
if any article to read more about these thing,, can you refere to me...
Thanks and looking forward.-MALIK
I have a USERS database table with a column called IsValidated. It identifies if a user has been validated.
I'd like to know which datatype would be the most efficient for this column.
Our DBA made it a varchar(1) column. Would using int be better?
Please advice.
I have a message box or multiline textbox on my form and I am storing into an SQL DB. I currently have it as a VARCHAR, but that doesn't seem to store the carriage returns. Do I have to store them as a nvarchar, text, ntext or something else to make the returns show? I am pulling them out of the DB and showing them in a label where I replace the with a <br>.
tempMessage = Dr("Message")
message.Text = tempMessage.Replace("", "<br />")
Is there a datatype that I can use to store a 64 bit unsigned int? I'm using SQL 6.5. Was thinking of using the standaed Interger datatype.
View 2 Replies View RelatedI am trying to convert a NVCHAR datatype to a DATETIME data type is that possible???
View 9 Replies View Relatedlakshmi writes "i want to store more than 8000 chars in varchar field.what can i do?"
View 1 Replies View RelatedHello Harish,
The data type is a varchar(10)
The Loan Number looks something like this:
254009411
Thanks,
Kurt
fathima writes "what data type is used to store unlimited content in sql server.
Actually i need to store a text book
pls reply i need it for a proejct work."
what date type is bet used when there is some occaions the user may enter 2.5 etc
View 2 Replies View Relatedi have a field in table x withe datatype bit.
if i store say value 64. it will store it as 1. then if i store another no. say 43 and so on.
then how do i retireve those values from table. say i want ot retrieve 64 the how will sql recoginze i want to retireve 64 as it is stored as 1 in the datafield
Over the years I have always used the decimal(18,0) as the datatype forprimary keys. Aside from the number of significant numbers involved,would BigInt type be better for performance or is decimal(18,0) still okay.--Don VaillancourtDirector of Software DevelopmentWEB IMPACT INC.phone: 416-815-2000 ext. 245fax: 416-815-2001email: Join Bytes! <mailto:donv@webimpact.com>web: http://www.web-impact.comWeb Impact Inc. <http://www.web-impact.com>This email message is intended only for the addressee(s) and containsinformation that may be confidential and/or copyright.If you are not the intended recipient please notify the sender by replyemail and immediately delete this email.Use, disclosure or reproduction of this email by anyone other than theintended recipient(s) is strictly prohibited. No representation is madethat this email or any attachments are free of viruses. Virus scanningis recommended and is the responsibility of the recipient.
View 35 Replies View RelatedI am using Visual Studio .NET 2003 with SQL Server 2000. I am trying toinsert the date and time into a SQL database by using hour(now). I amhaving a hard time trying to figure out which datatype to use in SQL tostore this value. I have tried using datetime, char, nchar, text andnothing seems to work. Anyone have any ideas? Thanks!Regards, :)Christopher Bowen
View 4 Replies View Relatedhello,i m having a problem with the sql database.it does not accept 0(zero)asthe first number in the integer field.whenever i insert 01 it takes itas 1.similarly for 02 and so on till 09.i want 01. can anyone suggesthow to get.i m doing this on sql server.does sql server support?is thisthe problem of sql server?
View 4 Replies View Relatedhello !I got some problems here. I have an attribute that determines the unitof something,e.g. the size of using "mm" , the length of using "seconds"and something others may using "n-page", so ,which data type should Iuse. the "nvarchar" or others?thank you very much!*** Sent via Developersdex http://www.developersdex.com ***
View 4 Replies View RelatedHi,
Supposed the variable @number calculated and resulted as 0.75. I declared it as a FLOAT but it keeps giving me '0'.
Set @number = 6/8
I get the zero result. What datatype should I use for the correct result ?
Thanks,
Dror.
Hi guys
What are alpha values and what datatype stores them.
Hi,Sorry if this isn't the right forum...I'm getting a "System.ArgumentException: Column requires a valid DataType" on the following line of code: dcUserAnswer.DataType = System.Type.GetType("SqlTypes.SqlInt32") I'm using SQL Server 2003 & ASP.NET 1.1 Thanks,Jens
View 9 Replies View RelatedHi Everyone, In C# file: bool abc; (it is working)But in sql file: (bool is not working. What datatype should use for bool in the sql file?)CREATE TABLE sb_payment_history ( sb_dispensing bool NULL <================ not working because bool is not known. )GOThanks,May
View 1 Replies View RelatedPlease i need to display the money column in DataBase in an asp.net page but i get something like this 786.0000 how can i format it so that i get something like 786.00
Thanx