AntonioGK

Hello, You have to change the EXISTS to = I wrote a similar example using NorthWind Database [code] SELECT CustomerID, ShipCountry, ShipPostalCode, RequiredDate FROM Orders a WHERE ( RequiredDate =( SELECT TOP 1 RequiredDate FROM orders AS b WHERE a.customerID = b.customerID AND a.shipCountry = b.shipCountry AND a.shipPostalCode = b.shipPostalcode …

Hello, Do you have the code you are using? Maybe I can found something.

Hello, 1 - This is a windows form or a web form? 2 - are you using visual studio .net or The express edition?

Hello, You need to do something like this: [code] DECLARE @sql varchar(255) @sql = 'SELECT ColA, ColB, ColC FROM Table1 WHERE ' + parameterColumnName + ' Like ' + ''' + parameterPercent + ''' Exec @sql [/code] Hope this help you.

Hello, If you are using MS-SQL open the SQL Server Manager select the database then Action Menu->All Task-> Generate SQL Script. There you have many options to save your database as SQL script. Hope this help you.

Hello, This expression give you only the time. [code] CONVERT (varchar, GETDATE(), 114) -- this is the result -- 10:24:55:640 [/code] I hope this help you.