Microsoft SQL Server Forum

The following sql statement fails: SELECT IdFlight, OrganizerLastName + ", " + OrganizerFirstName + " Flt:" + FlightNumber As Concat FROM TableFlights Order By OrganizerLastName, OrganizerFirstName I'm trying to concatenate fields and words, but my asp.net page gives me an error saying " Flt:" is not a field. Thanks, Marvin

Hi to All, I need a query to Find out the max.length of string in a particular Column. For ex. In a table,One of the column name is EmpName, In this column I want to select max lenth of the String. Any one can help Me?

Okay I have 2 tables: Table A - holds a list of new hardware serial numbers and their corresponding model (no constraints or indexes) Table B - holds a distinct list of current serial numbers and the corresponding model numbers (primary key on serial_numbers) Since Table A has no constraints duplicates may exist. Additionally, table A...

I am inserting a record into a table that automatically generates unique ids (i.e. Primary Key). Is there anyway to return this id. As I am using this on ASP.net page and I really need the ID to update the page with the new details. I think on mysql there is something called LAST_INSERT_ID which does this.

Hi All, How do you convert int value to datetime datatype in sql server e.g 900mins to hh:mm:ss Regards Ola

Hi everyone Have a problem I would areally appreciate help with. I have 3 tables in a standard format for a Bookshop, eg Products Categories Categories_Products the latter allowing me to have products in multiple categories.

I want to create some volume metrics, and I need to produce a report that shows how many rows were inserted by minute into a particular table. This is a candidate for a simple GROUP BY select, except that that the INSERT_DT column in the table goes down to the second. I want to GROUP BY at the minute level. I don't know an easy way to...

Once I've converted my floats to chars using STR, is there an easy way to put commas in separating the thousands. i.e. convert 53000000.12 to 53,000,000.12 I'm thinking I'll have to do it with a user defined function and the various string functions myself but was wondering if anyone had an

Hi, I'd need to construnct an EXEC statement in my script I am pretty much stuck with data conversion. I need to compare a binary variable with a SID value to an actual SID found in ..sysusers. Whe I construct the EXEC statement the whol line has to be string and I need to find a way to use the binary data as string. So far, I tryed to...

Is there a length limit on retrieving Microsoft SQL Server text fields? Thanks Siobhan *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!

I apologize if this has been asked before- I searched google but could not find a concrete answer. I recently inherited a database whose t-sql code is written in a format that I find difficult to read (versus the format I have used for years). I have tested the queries below using the SQL Profiler, and both have identical costs. Is there...

Hi All We have an order processing database which includes the standard Order Header/Order Lines tables. I'm trying to write a query to get the average number of lines per order over a given period, and I'm stuck :-( I can get the number of lines per order with: SELECT COUNT(*) FROM OrderDetails INNER JOIN Order Header ON

Hi, I just want to know to turn this: CREATE TABLE . ( NOT NULL , (50) COLLATE French_CI_AS NULL , NOT NULL , (50) COLLATE French_CI_AS NOT NULL , NULL , NULL ) ON into this:

MSSQL2000 I have a table that contains customer transactions CustomerID Transaction TransactionDate .... I need to select the most recent record that matches a specific CustomerID.

hi, One of the table in my database is got locked. actually it has many dependencies in the database. i don't know where it has get locked. how can i unlock the table with out restarting database or system. any help is appriciated. thanks

Hi, I have a need to update all price fields in an SQL database. The new prices are in an excel spreadsheet (c:\db\update.xls). Unfortunately the structure of the Excel file is not the same as the SQL DB, as it is formatted for printing hardcopies and hence contains merged cells (purple) and formatting etc....(see excel.jpg) Also it uses...

I have a table that has values as follows: PersonID Degree 55 MD 55 Phd 55 RN 60 MD 60 Phd I need a create a query that will give me output like this:

Hello All, Short Version: How large can a MS SQL Server INT become? Long Version:

I know in SQL Server the terms Database and Catalog are used interchangably. But a table is also assigned a schema. As seen in the INFORMATION_SCHEMA.Tables View. I don't get what this schema qualifier is all about. Like if a table has a schema of dbo. Can someone explain the relationship the schema has and what it is? Thanks.

How can I update only the date portion of a datetime field? Example: datetime field = '3/12/1995 12:05:50 PM' How can I change just the day '12' to a '7' Thanks

Hi, I'm working on a system migration and I need to combine data from multiple rows (with the same ID) into one comma separated string. This is how the data is at the moment: Company_ID Material 0x00C00000000053B86 Lead 0x00C00000000053B86 Sulphur 0x00C00000000053B86 Concrete

I'm investigating a bug a customer has reported in our database abstraction layer, and it's making me very unhappy. Brief summary: I have a database abstraction layer which is intended to mediate between webapps and arbitrary database backends using JDBC. I am very unwilling indeed to write special-case code for particular databases. Our...

Hi all, I am having trouble to writing stored procedure to insert and update the 2 tables in sql server 2005. Here is my problem. I have 2 tables with following columns. TableName:BENEFIT_PDF 1)DOCUMENT_CK 2)EFFECTIVE_DATE 3)PDF_FILE_NAME 4)PDF_DISPLAY_NAME

What query do I use to list the primary key for each user table, i.e. TABLE | PRIMARY_KEY | Regards, Alan *** Sent via Developersdex http://www.developersdex.com ***

Hi I am trying to use the WAITFOR function to make each loop in a cursor occur every 4 seconds until the curdb is empty the prtocedure is as follows ---------------- start create procedure q_additionalrabatt @additionalrabatt float,