Database

USE takhlees

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET NOCOUNT ON

DELETE FROM accounts_summary

-- reset primary key

INSERT INTO accounts_summary (account_number, account_name, core_account, is_read_only) VALUES (10000000001, 'CASH', 'True', 'True')
INSERT INTO accounts_summary (account_number, account_name, core_account, is_read_only) VALUES (10000000002, 'ACCOUNTS RECEIVABLE', 'True', 'True')

DECLARE @client_id int, @client_cpr varchar(50), @client_name varchar(255), @account_number_string VARCHAR(50), @account_number numeric(38,0)

DECLARE		account_numbers CURSOR FOR
SELECT		clients.client_id, clients.client_cpr, clients.client_name
FROM		clients
ORDER BY	clients.client_name

OPEN account_numbers

FETCH NEXT FROM account_numbers INTO @client_id, @client_cpr, @client_name

WHILE @@FETCH_STATUS = 0
BEGIN
	INSERT INTO accounts_summary (client_category, client_id, cr_cpr_number, account_number, account_name) VALUES ('I', @client_id, @client_cpr, SCOPE_IDENTITY(), @client_name)
	-- get random from 1 to 7
	SET @account_number_string = RIGHT('0' + convert(varchar(1), DATEPART(WEEKDAY, GETDATE())), 1)
	-- get random from 1 to 365
	SET @account_number_string = @account_number_string + RIGHT('000' + convert(varchar(3), DATEPART(DAYOFYEAR, GETDATE())), 3)
	SET @account_number_string = @account_number_string + RIGHT('0000000' + convert(varchar(7), SCOPE_IDENTITY()), 7)
	SET @account_number = convert(bigint, @account_number_string)
	UPDATE accounts_summary SET account_number = @account_number WHERE account_id = SCOPE_IDENTITY()
	UPDATE clients SET account_number = @account_number WHERE client_id = @client_id
	
	FETCH NEXT FROM account_numbers INTO @client_id, @client_cpr, @client_name
END

CLOSE account_numbers
DEALLOCATE account_numbers

pc_dev wrote:

I have also tried "Jet OLEDB:Database Password = mypassword" but it dont work

_bstr_t ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source = Database1.accdb;User Id=admin;Password=blabla;")

I are Troll

DECLARE @EndDate DATETIME
    SET @EndDate = '20091230'

I are Troll

• Use set DateFormat dmy
• use set @EndDate = '12/30/2009'
• use set @EndDate = '20091230'
  

James Shao wrote:

which doesn't work

James Shao wrote:

got an error internet message

<br />
select @minval = min(stockval) from table where stockdate between d1 and d2<br />
select @mindate = stockdate from table where stockdate between d1 and d2 and stockval = @minval<br />

select @minval = min(stockval) from table where stockdate between d1 and d2;
select @mindate = stockdate from table where stockdate between d1 and d2 and stockval = @minval;

Luc Pattyn wrote:

What is its name?

Luc Pattyn wrote:

are there things you can do with it successfully?

I are Troll

Eddy Vluggen wrote:

"French Franc"

Luc Pattyn wrote:

really?

I are Troll

Luc Pattyn wrote:

the 'Œ' character (and eszet 'ß' and most accented characters used in Western languages) is part of code page 1252, whereas the French Franc and most other (possibly obsolete) monetary symbols are not.

I are Troll

DECLARE @TestTable AS TABLE (
    TestCol NVARCHAR(2) COLLATE Latin1_General_BIN
)
INSERT INTO @TestTable VALUES (N'₣')
INSERT INTO @TestTable VALUES (N'Œ')
SELECT * FROM @TestTable

pranavcool wrote:

i have read in couple of the site that the data type of the colum should be nvarchar or ntext for french characters to support.

pranavcool wrote:

When ever i tried to insert data or run a select query it returns as a question mark "?".

I are Troll