Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Derived comboBox in DataGrid. KeyDown doesnt work.
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")...- lak201
- Thread
- Replies: 2
- Forum: C# (C sharp): Microsoft
-
Convert function in join slows stored procedure
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(...- lak201
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
CONVERT() makes stored procedure run slow.
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(... -
Using case to select multiple rows in where statement
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... -
whats wrong with this statement using a cursor?
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...
