SQL Server :: Create View Or Function Failed Because No Column Name Was Specified For Column 2
Feb 17, 2011
I am creating dynamic view using two tables.one is emp_Tbl and 2nd table emp_salary which is created dynamically .creating view it gives error 'Create View or Function failed because no column name was specified for column 2.
my code is: create view [dbo].[Emp_Salary_pay] as select dbo.Emp_Tbl.Emp_Status, (select column_name + ', ' from information_schema.columns where table_name = 'Emp_salary' ) FROM dbo.Emp_Tbl INNER JOIN dbo.Emp_Salary ON dbo.Emp_Tbl.Emp_Id = dbo.Emp_Salary.Pay_Emp_Id
I am in the process doing drag n drop for gridview by column cell. For example: there is 5 cell in a column, user are able to drag the first cell and drop it as 3rd cell.I have find through the internet but has find no resource on it.
I want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value
How can i create a hyperlink to Grid view column, when i click this column it should open Word documentnt.Each Column row values does have seperate information.
I have a table converted from Access and the identity keys were lost. Now I need to make the id column the identity column, but it already has a lot of null values, how do I auto generate integer values for the null rows? The row ids are incremented, so if there is a way to auto increment the ids
I have created a web project using asp.net and visual web developer 2008. On my local project I created a new column in one of my MS SQL data tables and populated it with data. How would I create a sql script of the new column and data? I want to insert this into my live database on Godaddy?
I have a SQL Server 2005 database which is queried by a web service which is called by an aspx page.
I inherited a messy and inefficient project, and I was working on cleaning up a GridView by making it dynamic and by having consistent field names in the database when I started getting an error of - Sys.WebForms.PageRequestManagerServerErrorException: Invalid column name: 'ASSIGNED_TO'
Assigned_to does not exist in the database, in the web service, or in the website solutions in any place. It was the name of one of the fields in one table, which I changed to USERID so that either of two datasets would fit into a Gridview (all other fields were the same). I then replaced all references of ASSIGNED_TO with USERID, which is when the issues began. The first of the two queries below causes the exception to be thrown, but the second one does not. I have tested both with the WCF Client and with a query within SQL Server to verify that they do work, so the issue has to be on the website side.
sSQL = "select distinct B.BADGE_NBR, a.REGId,B.CYC_RTE, b.USERID, a.MTRREAD,A.NEWMTRNUM, a.COMPTIME, B.FA_TYPE, CASE WHEN A.MTRCOMMENTS <> 'Null' THEN '*' END as Comment,a.MTRLAT,a.MTRLONG,a.WOFAID, b.ADDRESS, a.MTRREADFLAG, b.ROUT_SEQ from MobileDataReturn a,WORKORDERDIPATCHFILL b Where a.RegId = b.REGID and a.WOFAID = b.FA_ID and B.CYC_RTE " & route & "' and b.USERID " & worker & "' and B.BADGE_NBR " & badge & "' and a.MTRREADFLAG " & readflag & "' and b.FA_TYPE " & fatype & "' Order by a.COMPTIME desc"
sSQL = "select distinct BADGE_NBR, REGId,CYC_RTE, USERID,MTRREAD,NEWMTRNUM, COMPTIME, FA_TYPE, CASE WHEN MTRCOMMENTS <> 'Null' THEN '*' END as Comment,MTRLAT,MTRLONG,WOFAID, ADDRESS, MTRREADFLAG from MobileDataReturnArchive Where CYC_RTE " & route & "'and USERID " & worker & "'and BADGE_NBR " & badge & "' and MTRREADFLAG " & readflag & "'and FA_TYPE " & fatype & "' Order by COMPTIME desc"
Heres the situation: I need update a column from my table (T1) from two other columns in a different table (T2).
My constraints are:
That I have to match the first 4 letters of a column in T2 to one column in T1 I have to identify that the first letter in a column in T1 corresponds to one letter in the middle of a string in a column in T2 For instance:
My Table (T1):
Order Type Combined Place 0090 0001 YYXX 1YY 0091 1001 YYXX YYY 0092 1002 XXXX 2XX
Table 2 (T2):
Order Value 00900001YY XX 00911001YY XX 00921002XX XX
The Combined column in T1 is what i'm trying to complete. The T1.Place column contains the first character that I want to check for.
If it's a "1" then I want to make sure the 5th letter in T2.Order is a "0" If its a "Y" then I want to look for a "1001" If its a "2" then I want to make sure the 8th letter is a "2" in T2.Order If all that matches then I was the last two letters in T2.Order + T2.Value to be combined and put into the appropiate spot in T1.Combined
Here's what I have:
[Code]....
I know it's a little complex, but i'm really stuck on it and any help would be greatly appreciated.
I am facing a problem here. I have a column where the value is equivalent to my identity column's value. For an example, I have a column A store is "ABC0001" and the 0001 is came from a column called Column B which identity on. when a new record inserted and Column B is next identity number and Column A value is "ABC" and add number from Column B.
I am looking to sort a column on my gridview by simply clicking on the column rather than clicking on the column header. In the design I have been given, the column header will not be shown, and I need to be able to give the user to sort this column, by simply just clicking any where on the column.
If there's a 0 in the field the code inserts a null. Otherwise it inserts a date. How can I change this to insert a NULL if a question mark "?" appears in the column?
This is what I tied using the OR operator but it's not working:
I have a view created that I want to use as my datasource, however to enable to generate insert/update commands it specifies I must have all primary keys selected. Is there a way to set a column as a PK, or unique, within an already created view? And how?
I have a database call that is comparing UserID column of two tables. The UserID is a uniqueidentifier. The page errors on the r.read() line with Conversion failed when converting from a character string to uniqueidentifier. I'm not sure how to code this to avoid the error.
cmd.CommandText = "SELECT a.CenterName FROM Centers a INNER JOIN UserInfo u ON a.CenterID = u.CenterID WHERE u.UserID='{ + SessionManager.UserID + }'"; r = cmd.ExecuteReader(); r.Read();
I am not understanding why I am getting the following error (also mentioned in the subject line). I have written the following function in SQL Server 2005:
CREATE FUNCTION dbo.GetCandateID() RETURNS INT AS BEGIN declare @candidate_id int SELECT @candidate_id = max(c.candidate_id) from dbo.candidates c if(@candidate_id is null) set @candidate_id = 1001 else set @candidate_id = @candidate_id + 1 return @candidate_id END
The function compiled properly. I have used the above function like below in the query:
select dbo.GetCandidateID()
I am getting the following error: Cannot find either column "dbo" or the user-defined function or aggregate "dbo.GetCandidateID", or the name is ambiguous
I want to create a temporary table where the columns of that temporary table needs to be dynamic (those columns needs to come from the rows of another table)
I'm currently working on a small project and therefore created a gridview, including one bit column which has been linked with a checkbox in both the itemtemplate as the edititemtemplate (autopostback = true).Databinding for these two checkboxes has been linked (two-way) to the bit column.Now I want to display the gridview to end-users. They should be able to just click on the checkbox so they value in the database column gets changed as well (as I want to run update queries behind it), but not passing via the command column 'EDIT'.=> problem I'm having now is that the bit column in the database doesn't get updated.
I'm currectly tryin to access a specific value in my database in a specific column. I'm tryin to use the primary key of the table to access the actual value in the row of that ID.
The current code:
[Code]....
Just iterates through the table and looking for any row with the boolean 'checkin' value is True, then it takes the 'id' value of that row and stores it into an array. Is there a way that I can access a another entry, and only that entry, in the table with the 'id' stored in the array?
Like if my data base contained and int, primarykey, `id` value, a boolean, `checkedin` value, and a `time` value, is there a way to access, lets say, the row with `id` equalling 3 and and the checkIn value from that row?
