SQL Server :: Stroed Procedure To Combine String And Int?

Jul 20, 2010

I am wanting to produce and SQL stored procedure that will combine a the CompanyID with the CompanyName I order to display this in a drop down list/This is what i have so far....

Select CompanyID + ' - ' + CompanyName As DisplayName, CompanyID From Company

The error I get says:

"Conversion failed when converting the nvarchar value 'testcompany' to data type smallint."

Now Im presuming this is caused by the CompanyID being an int and the CompanyName being a string.

View 2 Replies


Similar Messages:

How To Combine A String With A Variable In Bind() In An .aspx File For A DataList

Oct 21, 2010

I have a DataList containing an ImageButton whose ImageUrl property I want to set by combining it with a string returned from a codebehind file property and a database value.

I have a protected property in my codebehind called strPath.

I want to combine it with a database value in my aspx file. Like so:

[Code]....

View 1 Replies

SQL Server :: How To Combine Multiple Rows Into A Comma-delimited List In Sql Server In Build Function

Jan 10, 2011

How can I combine multiple rows into a comma-delimited list in sql server in build function?? in HCL

examples :

X
---
12
15
18
20

Output : 12, 15, 18, 20

with in build function of sql server.

View 6 Replies

SQL Server :: Combine Two Querys Into One?

Feb 9, 2011

My query below

SELECT
WORKORDER
WORKORDER
[dbo]
WORKORDER.ACCT, MASTERFI.NAME1,
.TICKET_RECV_DT, WORKORDER.WORK_ORDER_NUM,
.LAST_ACTION,WORKORDER_DETAIL.WORKER
FROM [dbo].WORKORDER,
.MASTERFI, [dbo].WORKORDER_DETAIL.......

I want to combine two querys into one, how do i achieve this result?

View 4 Replies

SQL Server :: Combine Two Queries In One Resultset?

Sep 6, 2010

I want to combine two queries like :

select name as name1 from table1 where id = 6

and

select name as name2 from table1 where id = 2.

I need a single resultset. How can I do that?

View 26 Replies

SQL Server :: Combine Two Rows Of Data?

Mar 9, 2011

have a complex sql stored procedure which involves several unions.The unions also involveat from views. When the data is returned, it might look like the following.

ProductId Name Amount Buyer Date YearsAsCustomer
1 Jones 234.44 Nichols
1 Jones 3/12/2011 3
2 Melon 333.00 Tripol
2 Melon 3/23/2011 4

This is just a simple example, but notice how the records with the same product Id can be combined?Because one record has some of the data I need and the other record has different data. So essentiallythey should just be in one record together. So the output should look like this:

ProductId Name Amount Buyer Date YearsAsCustomer
1 Jones 234.44 Nichols 3/12/2011 3
2 Melon 333.00 Tripol 3/23/2011 4

How can I combine these records together? In the stored procedure the query is build in a parameter stringnamed @SQL, and then the query is executed by using the EXEC command:EXEC sp_executesql @SQL.Is their anway I can combine all of the outputted records into one record. Where the records I want to combine
have the same ProductId (As in the example I illustrated above?)

View 7 Replies

SQL Server :: Combine Inner Joins - Get A Field Value From The First Statement

Sep 14, 2010

I have a select statement. I need to get a field value from the first statement. GOAL: Below is what I am trying to accomplish - the code below is not correct - Please modify the statement with the correct SQL Syntax. I want to query a table and based on the results I want to set the "If THE Else"statement to query then table with diffent inner joins.

SELECT * FROM CONTENTITEM CI
INNER JOIN CONTENTCATEGORY CC ON CI.CATEGORYID = CC.CATEGORYID
IF CI.FORMTYPE = 200 OR 300
SELECT * FROM CONTENTITEM CI
INNER JOIN CONTENTCATEGORY CC ON CI.CATEGORYID = CC.CATEGORYID
INNER JOIN CONTENTFORMFIELD CF ON CF.ITEMID = CI.ITEMID
WHERE CI.ITEMID = @ITEMID
ELSE
SELECT * FROM CONTENTITEM CI
INNER JOIN CONTENTCATEGORY CC ON CI.CATEGORYID = CC.CATEGORYID
WHERE CI.ITEMID = @ITEMID

View 10 Replies

SQL Server :: Can Combine Resultset Return By Union

Sep 30, 2010

Is there a way to row two and three of the result set be returned so that the

following query:

[Code]....

View 10 Replies

SQL Server :: Combine Two Self Referencing Queries In A Function?

Feb 23, 2011

I have a menu table which has a (mostly) unlimited number of levels/tiers:

[Code]....

I also have a working function which will give the up and down tiers based on a given MainMenuId:

[Code]....

My question is, is there a better way to do this such as combining the two querries? Every attempt I have made results in a "The Statement terminated. The maximum recursion 100 has been exhausted before statement completion"

View 4 Replies

How To Create Stored Procedure In Sql Server And Call That Procedure From C# Code

Sep 1, 2010

I am trying to create the following stored procedure in sql server Lat and Lng are the parameters being passed from c# code behind .But I am not able to create this stored procedureit indicates with error saying undefined column name Lat,Lng

CREATE FUNCTION spherical_distance(@a float, @b float, @c float)
RETURNS float
AS
BEGIN
RETURN ( 6371 * ACOS( COS( (@a/@b) ) * COS( (Lat/@b) ) * COS( ( Lng/@b ) - (@c/@b) ) + SIN( @a/@b ) * SIN( Lat/@b ) ) )
END
sqlda.SelectCommand.CommandText = "select *, spherical_distance( Lat, 57.2958, Lng) as distance
from business
[code]...

View 1 Replies

AJAX :: Combine Libraries Into 1 Js file To Reduce Requests To Server?

Jan 27, 2011

I am using ajax control toolkits and ajax extentions in my projects. and as you know it overhead some libraries to page. How can I combine them into 1 js file to reduce requests to server ???

View 2 Replies

Combine JQuery Client And Server Side Errors In Same Summary At Top Of Page

Feb 25, 2010

I am using JQuery for all of my client side validation and Asp.net validator controls for all of my server side validation. I am using an errorlabelcontainer to store the client side validations in a summary at the top of the page, which is the requirement. All works well. My problem is, I want to display the server side asp.net errors in the same errorlabelcontainer OR display all of the client side errors in the validation summary. Either way, Both errors need to be in the same place/div. Any ideas on how to do this? I thought of maybe using the asp.net validation summary as the errorcontainer in JQuery, but I cannot find the summary. This is what I have right now.

$("#aspnetForm").validate(
{
onkeyup: false,
errorLabelContainer: $("ul", $("#FormErrors")),
wrapper: "li"
});

If you need to see more code.

View 1 Replies

SQL Server :: How To Combine The Data From The Two Text Boxes And Store It In Single Column

Jul 30, 2010

I have two textboxes

1.To get the Hour

2.To get the Minutes

From user.

And in the back end... i would to Combine the data from these text boxes and store it in single column..
For eg.

If textboxHours.Text="11";
textboxMinuetes.Text="56";
In the backend it should store like..
MeetingTime (column name)
11.56

View 2 Replies

SQL Server :: Combine Strings Separated By Single White Space In Column

Mar 10, 2011

i have a column in table and need to combine words seperated by single space, i am using sql server 2005.

DECLARE @text varchar(256)
SELECT @text = 'Micro Tech'

--required output MicroTech

View 3 Replies

SQL Server :: Alter A Procedure From Another One Procedure?

Oct 9, 2010

How can I Alter a Procedure from another one procedure?

View 2 Replies

SQL Server :: How To Create Stored Procedure In Sql Server 2005 And How To Use That Stored Procedure

Oct 1, 2010

I have created stored procedure and student database and also asp.net application for asp.net page but it could not found stored procedure what is the mistake actually I don't no

View 7 Replies

Way To Get A String Output From Stored Procedure

Sep 29, 2010

i had a stored proc: How can i get the final select statement in the code behind.

ALTER PROCEDURE [dbo].[tgms_reclass_PO_bip](@po VARCHAR(20), @old_gl VARCHAR(20), @new_gl VARCHAR(20),@output varchar(500) out )
AS
IF (SELECT COUNT(*) FROM mm2po WHERE scode = @po) = 0
BEGIN
SET @output = '1'
SET @output = 'Invalid PO Number'
END
[code]...

View 4 Replies

ADO.NET :: Return A String Value From Stored Procedure

Mar 19, 2011

I'm having a hard time to return a string value. I usually do this by passing an int, which works just fine. Now, I need to pass a string but couldn't. Is this possible? Or int is only type that SQL can return?

View 11 Replies

Web Forms :: Grabbing String From Stored Procedure

Apr 9, 2010

I am having a bit of trouble pulling from a stored procedure of mine. I want to return a string, for this example I tried to grab the mail address which is a varchar in my database.

View 7 Replies

SQL Server :: Have A Stored Procedure Execute Another Stored Procedure During Time Period?

Jan 28, 2011

I could probably figure this out if I tried to, but I have been working so long on code, I'm a little fried

I have a stored procedure, and I want to execute another stored procedure during a time period of lets say 1/1/2011 to 12/31/2011

How Would I accomplish this?

View 4 Replies

DataSource Controls :: Sending A String To Stored Procedure Using An IN

May 18, 2010

I am confused here as to how to handle this. I have a stroed procedure that using the IN clause like so:

[Code]....

Now, partners can be either a single partner ID like so: 12345 or it can be many like: 12345, 22222, 33333Here is the sqlDataReader from my code:

[Code]....

When partner_list contains only one partner id like "12345" it works fine. If it has more than one then the DataReader states that there are no rows in the reader? I also tried to send the dealer list as a string with ticks, like '12345','22222','33333' but that doesnt work either.

View 6 Replies

DataSource Controls :: Stored Procedure Count To String

Jun 27, 2010

I have a several count stored procedures that are binding to gridview nicely for individual items. I now want a ful count of row so I use a stored procedure with:

[Code]....

Which works fine when testing in the DB and returns results like it should. My problem is that for the life me I cannot work how to display the results to a Label.Text or how to do it when my calendar has posted back thats where @LogDate comes from).

View 8 Replies

DataSource Controls :: Returning String Value Using Stored Procedure And Linq

Feb 7, 2010

I am having problems returning a string value through a stored procedure/linq to a label. Everything works fine if I return an integer value but I cant get a string value to bind to a label. I get the error message

Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value,
NumberFormatInfo NumberFormat) +201
Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +66
[InvalidCastException: String "System.Data.Linq.SqlClient.SqlPr" to 'Integer' is invalid‚]

This is the stored procedure
ALTER PROCEDURE test
AS
Select ProductName
From Products

This is the vb page
Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim db As New DataClassesDataContext
Dim product As Integer = db.test.ToString
Label1.Text = product
End Sub

This is the aspx page
<form id="form1" runat="server">
<asp:Label ID="Label1" runat="server" Text=""></asp:Label>
</form>

View 1 Replies

DataSource Controls :: Passing Query String Value To Stored Procedure

Mar 30, 2010

I'm trying to pass the text value of a text box as a query string value to a stored procedure. I was hoping someone could point me in the right direction. Button Code:

[Code]....

Stored Procedure:

[Code]....

The results page datalist:

[Code]....

Code Behind of results page:

[Code]....

I'm sure i've got this entirely backwards. However if I change the NULL value in the stored procedure with some string value (eg."Donkeys") it pulls all the values that contain "Donkeys" into the datalist on my results page.

View 2 Replies

Passing Null / Empty String To Oracle Stored Procedure?

Mar 1, 2010

We have an ASP.NET web service that invokes a stored procedure on our DB (Oracle 11g). The problem is that the call to the procedure blows up every time an empty string is passed as one of the parameters. We're seeing an ORA-01084 error, which indicates to me that call is failing before the procedure is actually run.

Here's the procedure, minus some logic that I believe is not relevant:

[Code]....

As an experiment, I modified the web service to pass null rather than an empty strings. When null is passed in, I see an error indicating "wrong number or types of arguments in call to 'CREATEREPORT."

I also tried passing DBNull.Value whenever the params were null/empty, but that resulted in the error

Parameter 'p_column_id': No size set for variable length data type: String.

(Of course, p_column_id was the empty parameter in this case).

So, how can I successfully pass empty strings as parameters to my stored procedure? We definitely want to allow the p_column_id parameter to be empty.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved