hi i am trying to rename a primary using sp_rename. but it keeps failing with message that the column is involved in dependencies. but i have already dropped all constraints on this table! any help please...more >>

Hi! what command should i include in the SELECT query statement so that i can filter away the duplicate record(see only unique row)...eg by time. Thks!...more >>

I have a business need to display some date specific data to a selcect group of users 3 bussiness days before everyone else is allowed to see it. THere are many fields I will be displaying across many tables. The date I am using is ONLY in the primary table (meaning I don't have to include or...more >>

hello! I have a hierarchy structure copied from excel to a table in databse SQL. Here is what i have in SQL table: Continent Country City Europe Norway Oslo Bergen Trondheim Sweden Stockholm Gotaborg Denmark Kopenhagen Aalborg Germany Hamburg Munche...more >>

I USE SQL SEVER 2000 I HAVE A TABLE IN A DB CALLED "Trend_Velocità" I HAVE A QUERY ON A ADO OBECT "SELECT * FROM Trend_Velocità" in a Vb program IF THE DEFAULT VALUE OF LANGUAGE IS ENGLISH NO PROBLEM If I set the default value to russian the vb instrucion give me the error : invalid object na...more >>

I have a column that have numbers & letters combined in a field. What sql command would remove the letters only, not the numbers? I have a table called “customer” and the column in that table is called “customtext4”. I want to change over 5000 records in this “customtext4” field ...more >>

Which is the more efficient way to clear the contents of a table: DELETE FROM tableName TRUNCATE TABLE tableName Or DROP the table then create it again? -- Chris Lieb UPS CACH, Hodgekins, IL Tech Support Group - Systems/Apps...more >>

I'm quering about 5 tables using inner join. On one of the tables i just want to count or sum up the results. Here is the example I'm trying to get working. When I add the SUM(Private.PrivateIDs) I get an error. Is something like this possible? SELECT Units.UnitServiceLine, Units.Un...more >>

I am looking at a table, using Enterprise Manager, that has several fields defined as Binary. All I seem to be able to see is the literal "<Binary>" in these fields. How can I view the actual values in these fields? How do I do a selection criteria on them? Thanks, Tom ...more >>

Hello, This is a tuff one not sure if it can be done with an SQL query, I'm thinking along the lines of an inner join, but I'm not really sure. I have a table that is used to refer to location_names as nodes and sites as the leaf nodes it is the site names that I want to return based on a ...more >>

Hello! I wish to use a variable i a query that can change under execute. Here are some of my rows, i wish to make the f3 colonne F1 F2 F3(my new colonne) 10 text 10 null text 10 null tesxt 10 11 text 11 null tekxt 11...more >>

Hello, The @parameters that I am receiving into my SQL query in SQL Serer 2000 Reporting Services are based on user selection from a drop down combo box. If the user selects a name it will return an integer. An alternative to selecting a single name the user can select 'ALL' of which will re...more >>

Does anyone have logic to take an hl7 file format and create a flat file. I am having a bit of difficulty.............. Any help would be a lifesaver.... Thanks Greg ...more >>

Hi, FYI, all about SQL is new to me. I would appreciate it if someone could help me on the following :- 1) I have one text file containing 8 fields separated by pipes (|) and 1000 of rows eg:- Chang|Michael|acno1234566|03052005|154.26|1|0|655426.26 - Is it possible to impo...more >>

Hi, I have a problem to run a query like this scenario: i have players in a table who have scored in many matches and i want to take the 5 latest. The latest i want to multiply with 1.0 and then after with 0.8, 0.6, 0.4 and finally 0.2. playerid round score 1, 10, 122 1, 9, 123 1,...more >>