hi
i am doing union of two queries and getting result. as we know datatypes should match
for query1 it has int 64
now how do i convert int32 to int 64. i am just putting dummy values in quey2 to match query1
Hi,
Can anyone help me figure out how to convert from type GUID to int32 format which will be the format to store in sqlserver database?
I have retrieved the UserId of a particular user in the current users profile (which is also a field in a row of data in table aspnet_Users) using this method:
MembershipUser user = Membership.GetUser(CreateUserWizard1.UserName);
and now would like to cast the following
user.ProviderUserKey type int32.
I thought the way to go was to use a GuidConverter by doing such as below by first assigning the user.ProviderUserKey in the _UserID variable and then calling:
TypeConverter converter = TypeDescriptor.GetConverter(_UserID);
Int32 newUserId = (Int32)converter.ConvertTo(_UserID, typeof(Int32));
But it blows up! any ideas?
thanks
~M
i am trying to save data from unbound datagridview but i get the error " format exception unhandled- failed to convert parameter value to a int32" the following is my code:
Private Sub btnPlace_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPlace.Click
' Modify the following code to correctly connect to your SQL Server.
Dim Connection As New SqlConnection("Server=.SQLEXPRESS;Initial Catalog=Store Management System;Integrated Security=SSPI ")
[code]...
i had writen a stored procedure for inserting vlaues frma form into sql but iam getting this error can any pls help me
Failed to convert parameter value from a String to a Int32
my stored procedureALTER PROCEDURE sp_addcustomer
(@customerid as int,
@fname as char(10),@lname as char(10) ,
@companyname as char(10),@email as nvarchar(50),
@address as char(10),@city as char(10),
@zip as char(10),@country as char(10),
@phone as nvarchar(50),@state as char(10)
)
ASinsert into customer(customerid ,fname ,lname ,companyname, email , address ,city,zip,country,phone,state)
values(@customerid ,@fname ,@lname ,@companyname,@email,@address,@city,@zip,@country,@phone,@state)
RETURN
CODE IN C# IS
SqlConnection cn = new SqlConnection(Session["conn"].ToString());
cn.Open();SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;cmd.CommandType = CommandType.StoredProcedure;cmd.CommandText = "sp_addcustomer";
//SqlParameter p1, p2, p3, p4, p5, p6, p7, p8, p9, p10,p11;cmd.Parameters.Add(new SqlParameter("@customerid",SqlDbType.Int));
cmd.Parameters["@customerid"].Value =CustomerID.Text;cmd.Parameters.Add(new SqlParameter("@fname", SqlDbType.Char));
cmd.Parameters["@fname"].Value = fname.Text;cmd.Parameters.Add(new SqlParameter("@lname", SqlDbType.Char));
cmd.Parameters["@lname"].Value = lname.Text;cmd.Parameters.Add(new SqlParameter("@companyname", SqlDbType.Char));
cmd.Parameters["@companyname"].Value = companyname.Text;cmd.Parameters.Add(new SqlParameter("@email", SqlDbType.NVarChar));
cmd.Parameters["@email"].Value = email.Text;cmd.Parameters.Add(new SqlParameter("@address", SqlDbType.Char));
cmd.Parameters["@address"].Value = address.Text;cmd.Parameters.Add(new SqlParameter("@city", SqlDbType.Char));
cmd.Parameters["@city"].Value = city.Text;cmd.Parameters.Add(new SqlParameter("@zip", SqlDbType.NVarChar));
cmd.Parameters["@zip"].Value = zip.Text;cmd.Parameters.Add(new SqlParameter("@country", SqlDbType.Char));
cmd.Parameters["@country"].Value = Country.Text;cmd.Parameters.Add(new SqlParameter("@phone", SqlDbType.NVarChar));
cmd.Parameters["@phone"].Value = Phone.Text;cmd.Parameters.Add(new SqlParameter("@state", SqlDbType.Char));cmd.Parameters["@state"].Value = state.Text;
cmd.ExecuteNonQuery();
cn.Close();
Response.Redirect("main.aspx?st=Employee added successfully");
I am attempting to build our first set of packages populating or DW. All of our source system primary keys are bigints (on the main tables at least). SSIS seems to have a problem dealing with bigint values, i.e. having to assign variables as doubles rather than int64, having to cast returning bigint values as float, or bigint sproc output parameters as double. It is all a bit messy (and possibly the most frustrating part of SSIS for me) - does anyone know if this problem is due to be fixed in any forthcoming release?
View 2 Replies View RelatedGood day everyone,
I have a question concerning the Execute SQL task.
Problem Statement:
I have a table containing the following sample data.
Catalog_ID, Product_ID, IsBlocked
56789, 1, 0
56789, 3, 1
23567, 1, 0
23567, 2, 1
The data types of the fields are:
Catalog_ID: bigint
Product_ID: bigint
IsBlocked: bit
I have two variables called "old_catalog_id" and "new_catalog_id" with the following values:
old_catalog_id: 56789
new_catalog_id: 11111
Now, I would like to select all the recods, whose Catalog_ID fields equals the value in the variable "old_catalog_id" and insert identical recods with the "new_catalog_id" value.
The result of that operation on my sample records is:
Catalog_ID, Product_ID, IsBlocked
56789, 1, 0
56789, 3, 1
23567, 1, 0
23567, 2, 1
11111, 1, 0
11111, 3, 1
blue: selected fields
green: inserted fields
My Solution:
In order to realize this solution, I have created the following tasks on the Control Flow.
1. Create an Execute SQL Task for the selection. (Name: Selection Task)
2. Create a For-Each-Loop for iterating on the result set. (Name: Loop on results Container)
3. Create an Execute SQL Task inside the For-Each-Loop container for inserting the new records. (Name: Insertion Task)
Configurations and Problems:
1. Selection Task:
General Tab:
Result Set: Full Result Set
SQL Statement:
select Product_ID, IsBlocked
from MyTable
where Catalog_ID = ?
Parameter Mapping Tab:
Variable Name -- Direction -- Data Type -- Parameter Name
User:: old_catalog_version -- Input -- Large_Integer -- 0
Result Set Tab:
Result Name -- Varibale Name
0 -- User::FullResultSet (which has the Data Type: Object)
When I execute this task, I get no records.
Thus, I have hard-coded the value of Catalog_ID in the Sql Statement parameter. Now, I get the correct 2 records in the result set.
Question 1: What am I doing wrong in the Parameter Mapping?
2. Loop on results Container:
Collection Tab:
Enumerator: Foreach ADO Enumerator
ADO object source variable: User::FullResultSet
Enumeration mode: Rows in the first table
Variable Mappings Tab:
Variable -- Index
User:: old_prod_id -- 0 (Data Type of "old_prod_id" is Int64)
User:: old_isBlocked -- 1 (Data Type of "old_isBlocked" is Boolean)
When I execute the package, it fails with the following error message:
Error: 0xC001F009 at SQL Tasks: The type of the value being assigned to variable "User:: prod_id" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
Thus, I have changed the data type of the variable "old_prod_id" to Object. Now, the package runs successfully.
Question 2: Why isn't the package accepting "Int64" as the data type of my variable, although the corresponding DB field has the type "bigint"?
3. Insertion Task:
General Tab:
Result Set: None
SQL Statement:
insert into MyTable
(Catalog_ID, Product_ID, IsBlocked)
values (?, ?, ?)
Parameter Mapping Tab:
Variable Name -- Direction -- Data Type -- Parameter Name
User::new_catalog_version -- Input -- Large_Integer -- 0
User:: old_prod_id -- Input -- Large_Integer -- 1
User:: old_isBlocked -- Input -- Variant_Bool -- 2
When I execute this task, it fails with the following error message:
Error: 0x0 at Insertion Task: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Catalog2Context_CATALOGS". The conflict occurred in database "XS_EC_CCH_PEGXSAP2", table "eSearch4.CATALOGS", column 'ID'.
Well, the message implicitly states that the value of the variable "new_catalog_version" has violated the mentioned FOREIGN KEY constraint. But I have set a breakpoint and I saw that the value was set correctly. So, it seems that the Execute SQL Task is not able to read the value of the variable correctly.
Question 3: What am I doing wrong in the Parameter Mapping, which causes the task not being able to read the value of the variables correctly?
Thanks in advance for your help.
Regards,
Samar
System.OverflowException: Value was either too large or too small for an
Int32. Why does this error originate in the following line?"SqlCommand cmd = new SqlCommand("SELECT Count(*) FROM Contacts", conn)........ ..........DataSetContacts.ContactsRow row = ds.Contacts.NewContactsRow();..................row["ContactNumber"] = Convert.ToInt32(txtContactNo.Text);" ContactNumber field is SqlDbType.Int.
I have written a function as below to pass some value and get aNOTHER VALUE DURING THE RUNTIME
-----------------------------------------------
Sub ExpiaryDate(ByVal Expr1 As String, ByVal Expr2 As String)
Dim strSQLDDL As String = "SELECT STATMENT "
Dim SQlCommand As New SQlCommand(strSQLDDL, mySqlConnection)
SQlCommand.CommandType = CommandType.Text
Dim Colleague_CN As String = Int32.Parse(Expr1)
Dim Course_ID As String = Int32.Parse(Expr2)
Dim parameterEventType_ID As SqlParameter = _
New SqlParameter("@Colleague_CN", SqlDbType.NVarChar, 50)
parameterEventType_ID.Value = Colleague_CN
SQlCommand.Parameters.Add(parameterEventType_ID)
Dim parameterCourse_ID As SqlParameter = _
New SqlParameter("@Course_ID", SqlDbType.NVarChar, 50)
parameterCourse_ID.Value = Course_ID
SQlCommand.Parameters.Add(parameterCourse_ID)
Dim myDataAdapter As SqlDataAdapter = New _
SqlDataAdapter(SQlCommand)
myDataAdapter.Fill(DivisionDataSet, "ExpiaryDate")
myDataAdapter.Update(DivisionDataSet, "ExpiaryDate")
DivisionDataSet.AcceptChanges()
End Sub
Everything was fine as far as i am passing an integer.
Now i need to pass a combination of numbers and letters( NVarChar)
HOW DO I GETAROUND THIS PROBLEM
WHEN I USE THIS FUNCTION I GET ERRORS
SOMETHING LIKE..... Input string was not in a correct format.
INDICATES --Dim Colleague_CN As String = Int32.Parse(Expr1.ToString)
AS AN ERROR
CAN ANYBODY PLEASE HELP
HOW DO I PASS A NVarChar instead
THANKS
Using c# in the compact framework, is there a way to do a parameterized query for counting the number of records where a specified column is null. I tried all of these, but none of them work:
cmd.Add(new SqlCeParameter("@IntColumn", SqlInt32.Null));
cmd.CommandText = "select count(*) from TableName where IntColumn is not @IntColumn";
cmd.Add(new SqlCeParameter("@IntColumn", DBNull.Value));
cmd.CommandText = "select count(*) from TableName where IntColumn is not @IntColumn";
cmd.Add(new SqlCeParameter("@IntColumn", SqlInt32.Null));
cmd.CommandText = "select count(*) from TableName where not IntColumn = @IntColumn";
cmd.Add(new SqlCeParameter("@IntColumn", DBNull.Value));
cmd.CommandText = "select count(*) from TableName where not IntColumn = @IntColumn";
cmd.Parameters.Add(new SqlCeParameter("@IntColumn", SqlDbType.Int32));
cmd.Parameters["@IntColumn"].Value = SqlInt32.Null;
cmdGetNumRead.CommandText = "select count(*) from TableName where IntColumn is not @IntColumn";
cmd.Parameters.Add(new SqlCeParameter("@IntColumn", SqlDbType.Int32));
cmd.Parameters["@IntColumn"].Value = SqlInt32.Null;
cmdGetNumRead.CommandText = "select count(*) from TableName where not IntColumn = @IntColumn";
cmd.Parameters.Add(new SqlCeParameter("@IntColumn", SqlDbType.Int32));
cmd.Parameters["@IntColumn"].Value = DBNull.Value;
cmdGetNumRead.CommandText = "select count(*) from TableName where IntColumn is not @IntColumn";
cmd.Parameters.Add(new SqlCeParameter("@IntColumn", SqlDbType.Int32));
cmd.Parameters["@IntColumn"].Value = DBNull.Value;
cmdGetNumRead.CommandText = "select count(*) from TableName where not IntColumn = @IntColumn";
cmd.Parameters.Add(new SqlCeParameter("@IntColumn", SqlDbType.Variant));
cmd.Parameters["@IntColumn"].Value = SqlInt32.Null;
cmd.CommandText = "select count(*) from Meter where IntColumn is not @IntColumn";
cmd.Parameters.Add(new SqlCeParameter("@IntColumn", SqlDbType.Variant));
cmd.Parameters["@IntColumn"].Value = SqlInt32.Null;
cmd.CommandText = "select count(*) from Meter where not IntColumn = @IntColumn";
md.Parameters.Add(new SqlCeParameter("@IntColumn", SqlDbType.Variant));
cmd.Parameters["@IntColumn"].Value = DBNull.Value;
cmd.CommandText = "select count(*) from Meter where IntColumn is not @IntColumn";
cmd.Parameters.Add(new SqlCeParameter("@IntColumn", SqlDbType.Variant));
cmd.Parameters["@IntColumn"].Value = DBNull.Value;
cmd.CommandText = "select count(*) from Meter where not IntColumn = @IntColumn";
Whenever I use a "is not" in the query I get an exception, otherwise it returns a count of 0 which is not accurate. Any help will be appreciated.
Dear Experts,Ok, I hate to ask such a seemingly dumb question, but I'vealready spent far too much time on this. More that Iwould care to admit.In Sql server, how do I simply change a character into a number??????In Oracle, it is:select to_number(20.55)from dualTO_NUMBER(20.55)----------------20.55And we are on with our lives.In sql server, using the Northwinds database:SELECTr.regionid,STR(r.regionid,7,2) as a_string,CONVERT(numeric, STR(r.regionid,7,2)) as a_number,cast ( STR(r.regionid) as int ) as cast_to_numberFROM REGION R1 1.00112 2.00223 3.00334 4.0044SELECTr.regionid,STR(r.regionid,7,2) as a_string,CONVERT(numeric, STR(r.regionid,7,2) ) as a_number,cast (STR(r.regionid,7,2) as numeric ) as cast_to_numberFROM REGION R1 1.00112 2.00223 3.00334 4.0044Str converts from number to string in one motion.Isn't there a simple function in Sql Server to convertfrom string to number?What is the secret?Thanks
View 4 Replies View RelatedAnybody noticed that SQL Server rounds up if the value is half waybetween two rounded values, but C#'s Decimal.Round(Decimal,Int32)rounds to nearest even number?[color=blue]>From MSDN: "When d is exactly halfway between two rounded values, the[/color]result is the rounded value that has an even digit in the far rightdecimal position. For example, when rounded to two decimals, the value2.345 becomes 2.34 and the value 2.355 becomes 2.36. This process isknown as rounding toward even, or rounding to nearest."I perform the same calculation sometimes on the web server in C# andsometimes at the database in T-SQL, but want to get the same resultfrom both calculations. Could anybody offer any strategies for dealingwith this?Thanks ~ Matt
View 3 Replies View Related
select convert(varchar(16), getdate(), 101)+LEFT(REPLACE(convert(varchar, getdate(), 108), ':', ''),4)
From above query I get
mmddyyyyhhmm
but it' s yyyy and hour can not be separated
04/12/200702:05
How can I separated the year and hour ?
Thanks
Daniel
hi all,
I'm using visual web developer and created a project with a mdf data file. how can I convert this file to MS ACCESS mdb file?
Thanks
hi friends i am using vwd 2005 i created a project now i want to upload it on the server, but i want which database i used in the database convert it into .bak file for upload it on the server how i convert it, i don't have MS SQL SERVER 2005 or any except vwd 2005.
View 1 Replies View Relatedhow to convert msaccess 2003 data to sqlserver 2005
View 1 Replies View RelatedHi all,
How to convert varchar value to int in SQL Server2000?
For example i'm having the varchar value '1,2,3,4'
i want to convert this to 1,2,3,4 that is i want to remove single quote (') at the start and end of the varchar value,
how to do this?
Thanks!
Hello! I need help to change this to @@Identity..Thanks! protected void Button2_Click(object sender, EventArgs e) {
SqlConnection con = new
SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ThesisConnectionString"].ToString()); con.Open(); SqlCommand com1 = new SqlCommand(); com1.Connection = con; com1.CommandText = "Insert into TransactionHeader values ('" + DateTime.Now + "', '" + DropDownList1.SelectedValue + "', '" + TextBox1.Text + "', '" + TextBox4.Text + "', '" + TextBox9.Text + "', '" + TextBox11.Text + "', '" + TextBox12.Text + "');select scope_identity() as returnidentity"; string xyz = Convert.ToString(com1.ExecuteScalar()); DataTable dt = (DataTable)Session["shoppingCart"]; for (int i = 0; i <= dt.Rows.Count - 1; i++) { String WasteType = dt.Rows[i][0].ToString(); double Volume = double.Parse(dt.Rows[i][1].ToString()); double Fees = double.Parse(dt.Rows[i][2].ToString()); double total = Volume * Fees; SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = "Insert into TransactionDetail values ('" + xyz + "', '" + WasteType + "', '" + Volume + "', '" + total + "')"; com.ExecuteNonQuery(); ClientScript.RegisterStartupScript(GetType(), "save", "alert('Record Saved');", true); } }
How can I convert a date to MMDDYY with Convert()?
View 3 Replies View RelatedHi, I am new to Sql.
My question is how to convert nvarchar like this "Wed Jun 16 19:14:23 2004 GMT" to standard datetime format?
Thanks!
Hi,
Can anyone tell me, how can I get the date format in YYYYMMDDHHMISS format.
For Ex: select convert(char(12),getdate(),112) gives me the result as
'20011115'. Now, how can I get the the result something like '20011115110020'?
If I do a query from SQL 7.0 and get the result "10" which is a hex value (0x0A), how do I convert this using something like convert or cast to show "a"
Is there anywhere that I can look for help? I can get it to show 0x0A using cast, but that is not what I want. I want a hex number without 0X0 in front of A. The A I can convert using something like Lower(A)
Thank you.
Hi, I am trying to convert 2 columns from varchar(255) to datetime, the format of the data in the columns is '02/02/2001', and 1 column from varchar(255) to money, the format of the data in this column is '12,340.00'.
When I run : select convert(datetime, Col004), convert(datetime, Col005), convert(money, Col007) from table1
I get a result upto 59,996 rows then get the error:
Syntax error converting datetime from character string.
Any help would be appreciated, I have to convert 4 tables with, 722834, 1113978, 115489 and 121983 rows respectivly.
Is there a way to install MS SQL 6.5 twice on the same server? I would like to install SQL into the following dorectories D:MSSQL and D:MSSQL2. Any help would be appreciated.
View 5 Replies View Relatedcan anybody convert this to T-SQl :
Select decode(trunc((d_vst_btcdte - nvl(n_per_birth,d_vst_btcdte))/10000,0),0,'no DOB',
14,'14-16',15,'14-16',16,'14-16',
17,'17-20',18,'17-20',19,'17-20',20,'17-20',
21,'21-25',22,'21-25',23,'21-25',24,'21-25',25,'21-25',
26,'26-30',27,'26-30',28,'26-30',29,'26-30',30,'26-30',
31,'31-35',32,'31-35',33,'31-35',34,'31-35',35,'31-35',
36,'36-40',37,'36-40',38,'36-40',39,'36-40',40,'36-40',
41,'41-45',42,'41-45',43,'41-45',44,'41-45',45,'41-45',
46,'46-50',47,'46-50',48,'46-50',49,'46-50',50,'46-50',
51,'51-55',52,'51-55',53,'51-55',54,'51-55',55,'51-55',
56,'56-60',57,'56-60',58,'56-60',59,'56-60',60,'56-60',
61,'61-65',62,'61-65',63,'61-65',64,'61-65',65,'61-65',
66,'66-70',67,'66-70',68,'66-70',69,'66-70',70,'66-70',
'71+') AGE
Can anybody convert to T-SQL;
select distinct to_char(sysdate,'FMDAY, MONTH DD, YYYY HH:FMMIAM') TODAY
, d_aaa_insthdg CNTRHD
, decode(trunc((d_vst_btcdte - nvl(n_per_birth,d_vst_btcdte))/10000,0),0,'no DOB',
14,'14-16',15,'14-16',16,'14-16',
17,'17-20',18,'17-20',19,'17-20',20,'17-20',
21,'21-25',22,'21-25',23,'21-25',24,'21-25',25,'21-25',
26,'26-30',27,'26-30',28,'26-30',29,'26-30',30,'26-30',
31,'31-35',32,'31-35',33,'31-35',34,'31-35',35,'31-35',
36,'36-40',37,'36-40',38,'36-40',39,'36-40',40,'36-40',
41,'41-45',42,'41-45',43,'41-45',44,'41-45',45,'41-45',
46,'46-50',47,'46-50',48,'46-50',49,'46-50',50,'46-50',
51,'51-55',52,'51-55',53,'51-55',54,'51-55',55,'51-55',
56,'56-60',57,'56-60',58,'56-60',59,'56-60',60,'56-60',
61,'61-65',62,'61-65',63,'61-65',64,'61-65',65,'61-65',
66,'66-70',67,'66-70',68,'66-70',69,'66-70',70,'66-70',
'71+') AGE
, sum(decode(d_vst_dontyp,'WB',1,0)) DRAW1
, sum(decode(d_vst_dontyp,'xx',1,1)) TOTAL0
dear all,
i have an XML that i want to create a database for it, so depending on this XML i need to create the right tables to store the information in tables and then call these info from the database instead of from XML.
it is a big XML but here is just one part, the other parts are the same:
<?xml version="1.0" encoding="UTF-8" ?>
- <RENTETARIEVEN date="04-12-2007 00:00">
- <GELDVERSTREKKER mvcode="AA" naam="ABN AMRO">
- <HYPVORM mvcode="aflosvrij">
- <PRODUCT mvcode="2000" mvproductcode="197" naam="Aflossingsvrije hypotheek" renteaangepast="4-10-2007">
- <VARIABEL>
<NHG>5.4</NHG>
<EW ew="75">5.6</EW>
<EW ew="90">5.9</EW>
<EW ew="100">5.9</EW>
<EW ew="125">5.9</EW>
</VARIABEL>
+ <VAST periode="1">
+ <VAST periode="2">
+ <VAST periode="3">
+ <VAST periode="5">
+ <VAST periode="6">
+ <VAST periode="7">
+ <VAST periode="10">
+ <VAST periode="12">
+ <VAST periode="15">
+ <VAST periode="20">
+ <VAST periode="25">
+ <VAST periode="30">
+ <PRODUCT mvcode="XX" mvproductcode="9045" naam="Internet hypotheek" overbrugging="6.6" renteaangepast="3-12-2007">
+ <HYPVORM mvcode="annuiteit">
+ <PRODUCT mvcode="1000" mvproductcode="286" naam="Annuïteitenhypotheek" renteaangepast="4-10-2007">
- <VARIABEL>
<NHG>5.4</NHG>
<EW ew="75">5.6</EW>
<EW ew="90">5.9</EW>
<EW ew="100">5.9</EW>
<EW ew="125">5.9</EW>
</VARIABEL>
- <VAST periode="1">
<NHG>5.3</NHG>
<EW ew="75">5.5</EW>
<EW ew="90">5.6</EW>
<EW ew="100">5.6</EW>
<EW ew="125">5.8</EW>
</VAST>
- <VAST periode="2">
<NHG>5.3</NHG>
<EW ew="75">5.5</EW>
<EW ew="90">5.6</EW>
<EW ew="100">5.6</EW>
<EW ew="125">5.8</EW>
</VAST>
- <VAST periode="3">
<NHG>5.3</NHG>
<EW ew="75">5.5</EW>
<EW ew="90">5.6</EW>
<EW ew="100">5.6</EW>
<EW ew="125">5.8</EW>
</VAST>
- <VAST periode="5">
<NHG>5.3</NHG>
<EW ew="75">5.5</EW>
<EW ew="90">5.6</EW>
<EW ew="100">5.6</EW>
<EW ew="125">5.8</EW>
</VAST>
- <VAST periode="6">
<NHG>5.3</NHG>
<EW ew="75">5.5</EW>
<EW ew="90">5.6</EW>
<EW ew="100">5.6</EW>
<EW ew="125">5.8</EW>
</VAST>
- <VAST periode="7">
<NHG>5.4</NHG>
<EW ew="75">5.6</EW>
<EW ew="90">5.7</EW>
<EW ew="100">5.7</EW>
<EW ew="125">5.9</EW>
</VAST>
- <VAST periode="10">
<NHG>5.4</NHG>
<EW ew="75">5.6</EW>
<EW ew="90">5.7</EW>
<EW ew="100">5.7</EW>
<EW ew="125">5.9</EW>
</VAST>
- <VAST periode="12">
<NHG>5.5</NHG>
<EW ew="75">5.7</EW>
<EW ew="90">5.8</EW>
<EW ew="100">5.8</EW>
<EW ew="125">6</EW>
</VAST>
- <VAST periode="15">
<NHG>5.6</NHG>
<EW ew="75">5.8</EW>
<EW ew="90">5.9</EW>
<EW ew="100">5.9</EW>
<EW ew="125">6.1</EW>
</VAST>
- <VAST periode="20">
<NHG>5.7</NHG>
<EW ew="75">5.9</EW>
<EW ew="90">6</EW>
<EW ew="100">6</EW>
<EW ew="125">6.2</EW>
</VAST>
- <VAST periode="25">
<NHG>5.7</NHG>
<EW ew="75">5.9</EW>
<EW ew="90">6</EW>
<EW ew="100">6</EW>
<EW ew="125">6.2</EW>
</VAST>
- <VAST periode="30">
<NHG>5.8</NHG>
<EW ew="75">6</EW>
<EW ew="90">6.1</EW>
<EW ew="100">6.1</EW>
<EW ew="125">6.3</EW>
</VAST>
</PRODUCT>
</HYPVORM>
- <HYPVORM mvcode="beleggers">
+ <PRODUCT mvcode="XX" mvproductcode="9050" naam="Internet hypotheek" overbrugging="6.6" renteaangepast="3-12-2007">
+ <VARIABEL>
+ <HYPVORM mvcode="hybride">
+ <PRODUCT mvcode="4000" mvproductcode="2316" naam="Meegroeihypotheek" renteaangepast="4-10-2007">
+ <HYPVORM mvcode="lineair">
- <PRODUCT mvcode="6000" mvproductcode="2509" naam="Lineaire hypotheek" renteaangepast="4-10-2007">
+ <VARIABEL>
+ <HYPVORM mvcode="spaar">
- <PRODUCT mvcode="7000" mvproductcode="3110" naam="Meegroeihypotheek" renteaangepast="4-10-2007">
+ <PRODUCT mvcode="7109" mvproductcode="7687" naam="Spaargroeihypotheek" renteaangepast="4-10-2007">
+ <HYPVORM mvcode="tradleven">
+ <PRODUCT mvcode="5000" mvproductcode="3214" naam="Levensverzekeringhypotheek" renteaangepast="4-10-2007">
+ <HYPVORM mvcode="unitlink">
+ <PRODUCT mvcode="8000" mvproductcode="1486" naam="Meegroeihypotheek" renteaangepast="4-10-2007">
</PRODUCT>
</HYPVORM>
</GELDVERSTREKKER>
i already started creating some tables but i need to know some good practice to o this. any help will be very appriciated
thanks
I want to do this
SELECT TOP 100 PERCENT CONVERT(smalldatetime, DOCDATE, 105) AS DOCDATE
FROM SQSDBA.D_DETAILS
WHERE (DOCTYPE = 'SSCB') AND (DOCNUM = 155)
ORDER BY ROWNO
It is returning a date as 13/12/2003 ???
Any Ideas ?
Michael
hi
how can i convert smallint to varchar
declare @over smallint
[rollover_txn] = CASE WHEN hh.[deint] & ' + CAST(varchar(5),@over)+ ' = ' + CAST(varchar(5),@over) + ' THEN 1 ELSE 0 END,
krmm
How do I convert a value in a qeuery to be displayed as money or currency?
Thanks,
www.myspace.com/drew22299
I'm trying to convert an int to a string in my expression in ssis. Is this possible? I keep getting an error and I've also tried the cast operator, can't figure it out! Can someone help?
@[User::Path]+ "DEN" + Cast(@[User::Counter] as string)
thanks,
Mike
Hi All,
Did anyone know or can tell me how I can convert SDF to XML? and XML to SDF? Is there are tools or any code for me can use?
My boss don't want to use Merge Replication/RDA to push data from PDA to PC because sometimes got error when he want to replicate data.
Hello, I am having trouble using CONVERT, I am using this select statement
Code Snippet
SELECT a.TaskId,a.Name,a.Description,a.StartDate,
CASE WHEN Convert(nvarchar,a.DueDate,101) = Convert(nvarchar,getdate(),101)
THEN
CONVERT(nvarchar,a.DueDate,108)
ELSE
a.DueDate
END as DueDate, a.NotificationRuleId, c.RowStateTypeId, a.CustomerId, a.CustomerIdent, a.SourceCustomerId, a.CreatedByUserId, a.CreatedDate, a.UpdatedByUserId, a.UpdatedDate, u.FirstName + ' ' + u.LastName as CreatedBy, r.Name as Status FROM Task a inner join AssignedTask c on a.TaskId = c.TaskId inner join UserAssignedTask b on c.AssignedTaskId = b.AssignedTaskId INNER JOIN [User] u on u.UserId = b.UserId INNER JOIN RowStateType r on c.RowStateTypeId = r.RowStateTypeId WHERE b.UserId = {0} and c.RowStateTypeId<>8
but if the statement hits the CONVERT section it formats the date as 1900-1-1 (time) instead of just (time) which is what I am looking for, is there any other way I can accomplish this?
Hello,
I am making reports with SQL and Reporting Services.
To day I wanted to convert a field to datetime.
It had to have the style of Holland, so dd-mm-yyyy.
I used the following code, which not gives the expected output:
Code Block
CONVERT(DATETIME, Objectplaatsingsdatum, 105) AS Objectplaatsingsdatumconvert
It gives output like:
7/1/1992 12:00:00 AM
It is sure not what i wanted.
Can someone tell me what I do wrong?
The 105 stands for the style I wanted, so I do not know where it goes wrong.
Thanks,