Hi,

What do you mean by table variable???

Hi,

What are you using Access, MSSQL 2000 or MSSQL 2005

Hi,

My friend, your question have nothing to do with MSSQL, you should have posted it in Vb.net forum and i think you will need to use Cellstye.forecolor=Color.green

Hi,

This is an excellent forum but it is not specialized in DBs. In fact you will find alot of sites only intrested in MSSQL but I don't think you will find those expert examples you are looking...

Hi,

I don't know if I got u but try:

SELECT TOP 1 part_no, curr_date, cost_layer_qty
FROM inv_tran
WHERE (cost_layer_qty < 0)
ORDER BY cost_layer_qty DESC

Hope this works for you.

Hi,

Try this:
SELECT CONVERT(varchar, BROUTE) + ' ' + CONVERT(varchar, BACCOUNT) AS [Group], SUM([VALUE]) AS Total
FROM tblExample
GROUP BY CONVERT(varchar, BROUTE) + ' ' + CONVERT(varchar,...

Hi,

How are you updating the table. 10K is not that big number when speaking about data bases.

Hi,

Create a stores procedure (called ex: CustInfo) and forward it the customer code to search for. The body of the procedure will be:
CREATE PROCEDURE CustInfo(@CustCod int) AS

IF (Select...

Hi,

You have to ways either export data from MSSQL to Excel or import it from excel to mssql:
For the first choose the database >> right click >> All tasks >> Export data >> choose the data...

Hi,

There are 2 ways, detach, backup, and attach. Or generate Script.
First the first one you will need to right click database and in all tasks sub menu choose detach database. Now go to the...

Hi,

You have to use the EXEC function but after some conc. ex:

EXEC('select ' + '14200 * 5')

you may need to use stored procedures.

Hi,

The problem that you will have to Detach the Database (which will disconect it) copy the files xxx.mdf and xxx.ldf from the "C:\Program Files\Microsoft SQL Server\MSSQL\Data" folder reattach...

Hi,

Or add .0 to the numbers:

select convert(decimal(5,2),(7058.0/7482.0)*100 ,0)