Hi, I am experimenting with the Recursive Queries using Common Table Queries. I get an error with the one I made. What is the error with the 1st line that is below (That is where the error is shown). Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'WITH'. If ...more >>

Guys help needed, I have a table X DocNo | InvNo | VAT | Anount ---------------------------------------- 1 | a1 | 7 | 100 1 | a1 | 22 | 200 2 | a2 | 0 | 50 3 | a3 | 22 | ...more >>

Hi, I'm executing a "backup database" query in Java using a CallableStatement object like this: String query = "backup database TestDB to DISK = 'c:\TestDB.bak';"; CallableStatement call = m_dbConnection.prepareCall("{call sp_executesql(@stmt=?)}"); call.setString(1, query); call.execut...more >>

This is very odd. I can setup the Back Up Database Task in the Maintenance Plan of SQL 2005 -- and hand select some databases --- yet it doesn't actually generate any backup script for a few of the databases. They are NOT in simple recovery mode and I can backup the tranlog just fine from...more >>

I'm having trouble with CLR based user-defined functions. When I create a database C# project in Visual Studio 2005, the dialog to pick the database connection doesn't apprear. Except for that, the project seems to be created normally. I am able to write and build my project without a p...more >>

In Access you can do Format$([time],"hhnnss") and it will format 3:02:07 pm to be 150207 and 3:16:19 pm to be 151619. What is the best way to do this in SQL Server ? Thank you. ...more >>

I am trying to move .doc, .xls, .pdf, .jpg fields to a SQL-Server 2000 image field using writetext. I am using a RichTextBox control to hold the binary data. All examples I have found for writetext are writing 'Hello World' or something else inside of tics. I can't find anything where an ac...more >>

Hi all, I need SQL Server code to clean address fields. Any suggestions? Audrey *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have an invoice file that contains the item code of a product as well as the date. I also have a historical price sheet that lists the item code, price, begin date of the price, end date of the price. I need to add the price from the price sheet to the invoice file but I could have multiple...more >>

Hi, Using SQL 2005, what would be the best way to generate INSERT statement for all data within one table or all tables within our database? Any help would be appreciated, Max ...more >>

Hello, I have an SQL database with a table. This table has two fields: [Title] and [Description]. In my web site I have a text box where the user inserts some keywords, as follows: 1 > book english 2 > book AND english 3 > book OR english Is it possible to create an SQL procedure...more >>

It's my understanding that SSB can't message P2P between SQL Express Editions on multiple machines. Is this true? Is it possible to put a Q on a non-Express Edition machine that just routes messages between Q's on Express Editions? Thanks, Mike ...more >>

I've tried everything to get rid of this error in this code: SqlConnection cnSQL = new SqlConnection(ConnectionstringCTLG); SqlCommand cmSQL; int intRowsAffected; string strSQL = "Select p.name, " + " pc.sort_order " + ...more >>

I am moving XML into a table variable. I declare the table variable, load the data then load the other part of the xml to another table variable. Then I drop the XML from memory and try an IF EXISTS... it tells me I must declare the variable @Supplier and @TPConfig even though they are already...more >>

Hi, I'm looking for a bit of general advice on how best to go about solving this problem: I need to store a list of unique urls. This list will be updated every day by adding 400 or so new urls. Some of these urls (maybe upto about 65%) will be duplicates. Whats my best way of making sur...more >>

Hey can anyone help with this? Below is a table that shows some parts against month and a vendor ID number. I would like to put together a statement, that, where the VENDOR_ID is NULL for a month, looks back at the previous month for the same PART to get the vendor ID. It is possible, as in...more >>

Hi, I have this piece of code which works perfectly but it is not including the Headers. Here is my code. SET @Command = 'bcp ' + '"USE ' + DB_NAME(DB_ID()) + ' SELECT FirstName,Surname,Postcode1,Postcode2,SCRef ' + 'FROM dbo.vw_BestPriceReport_SimpleCover_DailyJob' + '"' + ' qu...more >>

in oracle we have a functionality "cursor" ... do we have some replacement of it in sql server Example of oracle "SELECT 'INVOICES' AS EXT_TABLE_NAME, TRANSACTION_CODE, WAYBILL_NUMBER, CURSOR ( SELECT 'INVOICE_LINES' AS EXT_TABLE_NAME, EXT_REC_ID , UNIT_PRICE FROM INVOICE_LINES ) INVOI...more >>

I am at a loss to understand why SELECT BASIC,(1+FLOOR(LOG10(BASIC))) as wid FROM SALHIST; works and returns the expected results but SELECT BASIC,(1+FLOOR(LOG10(BASIC))) as wid FROM SALHIST ORDER BY BASIC; returns no results at all, and why SELECT BASIC,(1+FLOOR(LOG10(BASIC))) as wid ...more >>

I have a stored procedure which has a WHERE clause in it, there are two parameters WHERE n=@n AND o=@o I want to pass a parameter which will form the remainder of the selection. AND MarketSpace = @MarketSpace. BUT, I want to be able to select ALL market spaces if the @MarketSpac...more >>

I have a record set of 25,000 records ( which is growing ). For the sake of the example, the view looks like this. pyear( int ) week_no( int ) marketSpace( string ) project_no( string ) cost( double) I want to group by market space , project_no and then sum the cost. So far, so good ....more >>