I Want to select TOP 2 records for each of the INDICATOR
CREATE TABLE ABC
I want to insert >= & <= into database.
Please see attached query.
create table test123
insert into test123
values ('Â¡Ã Â¡Ãœ')...
How can I convert numeics to words
e.g. 837 to Eight Hundred and Thirty Seven
I want to print + "Plus-Minus" as a text in SQL. e.g. I want to store +2% rather than +-2%.
How can I store this?
I have a database with 60 tables. I want to create another database(separate server) with only 15 of these tables for reporting. I do not want to...
I've a table with following data
I want to fetch result as 'Red, Blue, White, Yellow' in a single SQL Query.
I've a table TestInvoice
UID Buyer Vendor Agent
----------- ---------- ---------- ----------
1 B1 V1...
I am trying to run scripts using OSQL/ISQL. Both time I am getting the error "Incorrect syntax near 'Ã¿'". If I copy the scripts on Query Analyser,...
How can I traspose result in SQL
Say, I got result from Select query like
I have two users in database,
I create table dbo.User_View with following data
Separate names with a comma.