I am trying to combine two columns in SQL query but getting the following exception in java.sql.ResultSet's FindColumn method: JdbcSqlException: The column name FullName is not valid. Column: 'FullName' Here is my SQL query SELECT U.FirstName + ' ' + U.LastName AS FullName FROM User as U Anyone? Please note that query runs ...
Hi. I'm trying to figure out how I can dynamically hide/unhide parameters for a Reporting Services report I've created via a URL query string. I've tried reading a whole bunch of stuff I found through a Google search and I've also tried reading various MSDN documents regarding SQL Server, but I have yet to find a way how I can pull this ...
The short version is I am looking for a way to prioritize certain tasks in SSIS 2005 control flows. That is I want to be able to set it up so that Task B does not start until Task A has started but Task B does not need to wait for Task A to complete. The goal is to reduce the amount of time where I have idle threads hanging around wait...
How i can get list of parameters from report using ReportingService2005 API? ...
Suppose I have this data: Employee Task IsCurrent -------- ---- --------- Jeff 1 Yes Jeff 2 No Jane 1 No Jane 2 Yes Jane 3 No Jane 4 No Jake 1 Yes Employees have some number of tasks, and one of them will be current. The task number indicates an ordering -- t...
Thank you for your help in advance. I am looking for a neat solution for the following update scenario: I have a table TableA with 5 columns (KeyCol, colA, ColB, ColC, ColD) I have another table Table2 with 2 columns (KeyCol, AvgCol) I want to do something like this: update AvgCol in table2, joining on KeyCol from this logic: if...
I have XML (see below). I need to insert the records in this XML file into a SQL Server 2005 table using SSIS. I'm stuck with the xsd file description. Within Visual Studio when I click the Generate XSD button I get the message "Unable to infer the XSD from the XML file. The XML contains multiple namespaces." Does anyone know of a g...
I am using MS SQL server 2005 I have a table with 3 columns where I store user-message mapping like: msg_for msg_from msg_id bob bob 1 bob john 1 bob steve 1 bob bob 2 bob john 2 bob bob 3 bob john 3 bob steve 3 The PK is on 3 columns and msg_id is FK to message...
Don't ask me why, but I have to migrate a database from 2008 to 2005. This is not an issue of itself, but I have a very large table. When I script the tables contents (using Generate Scripts), the .sql file made is over 4gb. This is more memory than the server has available in RAM. Is there anyway to generate insert commands that split...
Finding Duplicate Row with Count Numbers Suppose a table is given ID Name Age ----------------- 1 Jon 30 2 Skeet 30 1 Jon 30 4 Gravell 30 5 NULL 30 4 Gravell 30 5 NULL 30 7 James 40 Required output (NULL also should comparable) ID Name Age Desc...
Hi All, I want to find the version, SP applied (CU if any) applied on SQL server. I am able to get verison no. using @@VERSION. But I want the whole list of patches/SP applied to it. Can you please help me out. Thanks, Sunil ...
Hi, Recently in an interview I was asked to write a query where I had to fetch nth highest salary from a table without using TOP and any sub-query ? I got totally confused as the only way I knew to implement it uses both TOP and sub-query. Kindly provide its solution. Thanks in advance. ...
Hi, I want to pass 2 parameters to SQL stored procedure and use "like" statement as so: CREATE PROCEDURE dbo.StoredProcedure1 @project varchar(max) @group varchar(50) AS BEGIN SELECT * FROM table1 WHERE Projectname = @project and Resource_ID like '%' + @group + '%' END It says that there is incorrect syntax near @group a...
Hi, I have prepared an installer which will deploy some files as well as will create database, tables, procedures, etc. The problem is if the user wants to install db, procs. on remote server then I require SQL client to be installed on machine from where I am installing my application. I dont want to have this (as clients would not ag...
Hello ! Does anyone know a good and free Database Designer able to export the design into SQL Server 2005 ? I have been using PowerAMC for 2 weeks but it was the trial. PowerAMC is the only program I know with a Conceptual Data Model Designer. Thank you. ...
I have a table in SQL Server 2005 that looks like 1 | bob | joined 2 | bob | left 3 | john | joined 4 | steve | joined 5 | andy | joined 6 | kyle | joined What I want is to give someone the ability to pull up the activity of 5 random users (showing their latest activity) ex: I want to return results 1, 3, 4, 5, 6 - or - 2, 3, 4, 5, ...
I have a field with birthday which stores birthday as either '7/08/1986' or '07/08/1986'.this is field already in existing table which i can not change the definition of the field. I want to convert the value to be looking like this '1986-08-07'.kindly note down it shd not be like '1986/08/07'. fundamentally we have to convert from DD...
I would like to learn SSIS 2008. can any one guide me to get ebbok to learn SSIS 2008? ...
I am a nembie to CGI with Perl, please do help me out and please do correct me wherever I have committed a mistake. This is the code. The problem is that after the password is validated and found as correct, instead of redirecting to the next page it is giving this message: Status: 302 Found Location: http://localhost/cgi-bin/Main.cgi ...
I checked the size of the file itself - it said it's 4.02 GB. I checked the size mentioned in properties of the database using SSMSE - it said the size was somewhere above 4000 MB. I then executed sp_spaceused and it said that the file size was above 4500 MB and the unallocated space was close to 4100 MB. I'm a little confused as to ho...