Is it possible to change the following query so that the @classification can either be null - to return all records 'DB' to only return records where classification = 'DB' and ' ' to only return records where classification like ' ' here is what I have so far but it doesn't cater for the lik...more >>

New to SQl and would appreciate some help in executing a stored procedure where the criteria in a WHERE clause is more than one value for a given column. For example I use this when I pass a single value as UserID, but how could I filter the table if I have multiple values for the Where c...more >>

I really hope someone out there can help me out. When running a query, I want to fill an empty field with the "name" field minus the middle initial or suffix (JR, SR, etc). I know how to pull these off in Excel, Access, but I can't seem to do it in SQL query. PLEASE HELP - i would be fo...more >>

Hi have a the following snippet from a query where QotStat = coalesce(@Status, QotStat) If I don't give a value for @Status then all records are returned however what I want to achieve is that when I don't give a value for @Status I want records returned to be limited to where QotStat = 0 or...more >>

I just upgraded a system to SQL Server 2000. I have an access datadase that run's SQL queries. Now after the upgrade the queries no longer run. I know it is the access query but am unsure of how to rewrite then query. This is an example of one of many queries I use. SELECT datetime, meltr...more >>

Hi, I would like to merge two different tables running an SQL script thus I can export it to excel and then creat a flat file (.txt). Does someone know how the SQL should read? Thanks in advance Alberto -- Posted via http://dbforums.com...more >>

Does anyone know about to generate in Query Analyzer the Space Allocated Statistics that are graphically available in Enterprise Manager? What would be the correct query to run to generate this information? Thanks! Jarrad Wilkinson...more >>

hi All, As i am developing an application in Vb.Net. I want to take backup of SQL database. My application is Client server application. SQL server is on remote Machine. While taking back up i have to give the access to SQL server Machine only. if give the Path of Local machine it give th...more >>

Hello Sir I am facing a problem while using Cursors in Procedure Actualy the fetch is working properly when i Execute first time in query analyser.2nd time when i execute again the cursor is not fetching any data.The @@Fetch_status showing -1. Please help me how can i initialize @@fetch_statu...more >>

Hi, All I' Have 8Gb of transaction Log, is very big. It almost hang the server. Any way to decrease it or truncate it? Thanks. ...more >>

How do you rename a datafile on Sql Server?...more >>

MS Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to maintain t...more >>

Microsoft Partner this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to help...more >>

Hello, I'm trying to select some records from an SQL 2000 database. The Select statement is as follows: select * from test where field1 = '38˚' No records are retuned even though there are some content that matches the criteria. How do I select records that contain the degree '&#...more >>

I have written a couple of short functions I would like executed from within a stored proc. The create scripts run properly and i can see the objects in sysobjects - type = 'FN'. How do i execute the functions ?? I have been trying the following but i keep getting an error saying th...more >>

Hello, I have problems with a simple query. I do this: declare @fechas char(50) select @fechas=rtrim(convert(char (30),fec_publicacion,103)) from fechasavisos where cod_aviso=249731 and tip_aviso=2 print @fechas This query have 2 values. The variable @fechas must be keep 12/10/200319/1...more >>

Hello Again, I have since worked out what I need to replace some of the Access SQL Query with. I just need to take the output of my DATEDIFF a step further and convert the negative values to a varchar "No" output or a positive value to a varchar "yes" output where the IIF function was used ...more >>

Hello, I am currently taking a query used in Access and changing it to comply with SQL Server syntax. I am experiencing problems with the use of getDate() and the IIF function, and as such looking for an alternative means to extract data. CURRENT SQL ACCESS QUERY: (works in Access) -----...more >>

Hi all, This is probably a really easy question and I don't know why I can't answer it myself, but I can't and its frustrating me now after 2 days. I have a table:- cv_case_key decimal(9) case_section_section_key decimal(9) case_section_paid money(8) month_number decimal(9) ca...more >>

Hi all, I have the following issue. I need to join one table twice, parent child relationships stored in db table. I have figured out that aliases is the way to go. I can run a basic query in which the parent and child relationships are shown in the recordset. Once I convert this query to...more >>

Hi Does anyone of you know whether a post commit trigger (also called an after commit trigger) is supported in SQL Server. A post commit trigger is a trigger that is called after a transaction is committed. This is unlike the normal "instead of", "for" or "after" triggers supported...more >>

How do I impose the IDENTITY property on an existing column with data in it already? Scenario: Column "joe" is not an IDENTITY column Data imported into table and "joe" now has data. ***I want to now assign "joe" the IDENTITY property without dropping and re-adding the column. How do ...more >>

I am new to the SQL Statement building and i may be in the newsgroup to ask this but I am needing a statement to go back 1 month from today to query information before that time. I want it to do this each time i run the query not just a static date that has to be changed each time it runs...more >>