Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
2 17
Newest
 Caucus
Impact
~16k people reached

  • 0 posts edited
  • 0 helpful flags
  • 11 votes cast
Aug
6
awarded  Caucus
Apr
4
awarded  Necromancer
Feb
5
awarded  Notable Question
Sep
28
answered Large queries are slower in SSMS
Jun
25
comment Should I add it as an additional column or a seperate table?
you can make it accept nulls, or insert the division before the region. its more a question of how you use it and write to the db..
Jun
24
answered How to print ORDER wise using LEFT JOIN in SQL?
Jun
24
answered Save different account types in a database
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
and you should check to see if its really damages the performance because you cant guess stuff like that without making a real check
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
so you need to use a stored procedure or collect the table data once on each run to a local db and run the query there
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
run the cte/query for each one of the inputs you have and you will get correct results
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
you cant use it with in(value1,value2,...)
Jun
24
revised how to select column3 from rec1 value which is matched to column1 val in rec2
added 139 characters in body
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
thats not a stored procedure... and you dont need the create table / drop table / insert parts of the code because you allready have the data and table
Jun
24
answered how to select column3 from rec1 value which is matched to column1 val in rec2
Jun
24
revised Should I add it as an additional column or a seperate table?
deleted 2 characters in body
Jun
24
answered Should I add it as an additional column or a seperate table?
May
16
awarded  Popular Question
Apr
22
answered Query multiple rooms with different conditionals (Adults, Children)
Apr
22
answered ORM for Image model
Apr
22
accepted Is it impossible to store 2^266 records on a database of some kind?