Recent content by lak201

hi everybody. i wanted to have comboboxes in my datagrid. so what i did was to derive a custom column style from the DataGridTextBoxColumn class, which i got from syncfusion. private void makeDataGridWithComboBox() { System.Data.DataTable dt = new System.Data.DataTable("trade grid")...

hi all, i am having a problem because sql does not have a "date" variable and has a "datetime" variable instead. i have 2 tables both with datetime fields, which should actually be just dates.. i have about 2-300,000 rows in each table. i have to do an inner join on the dates being equal(...

no.. and i am sorry i didnt mention it... but i am using SQL Server... but i think i can use this cast(date1 as int)=cast(date2 as int)... but is this any better than using the convert function.. thanks

hi all, i am having a problem because sql does not have a "date" variable and has a "datetime" variable instead. i have 2 tables both with datetime fields, which should actually be just dates.. i have about 2-300,000 rows in each table. i have to do an inner join on the dates being equal(...

thanks a lot to both phv and rac2. both your suggestions work fine. rac2,i have ana additional question for you. does it matter if i write (id1 = opt_arg1 OR opt_arg1 IS NULL) vs. (opt_arg1 IS NULL OR id1 = opt_arg1) i.e., is it better if i check for the null first, in terms of the...

hi all, please forgive me if this question is too naive. heres what i am trying to do: i have a stored procedure that takes in an optional argument which defaults to null. if its null i have to return all the values from a table, else return only those values that have a value match against...

thanks PHS. i will do that.

this is the message i get in the query analyzer: [Microsoft][ODBC SQL Server Driver]Syntax error or access violation. thanks

sorry , the 3rd line should be : DECLARE @DEALER VARCHAR(10)

hi, i am new to sql , so pls forgive if this is too naive DECLARE @CUSIP VARCHAR(50) --set @cusip='abc us equity' DECLARE @DECLARE VARCHAR(10) --set @dealer='gsco' DECLARE @BID FLOAT --set @bid=50 DECLARE @ASK FLOAT --set @ask=50 DECLARE @STOCK_REF_PX FLOAT --set @stock_ref_px=50 DECLARE...